[MDEV-6629] MIN/MAX and "HAVING func(DISTINCT)": wrong results - JIRA

Details

I know that this bug has been fixed by Oracle:
http://bugs.mysql.com/bug.php?id=69833

But their solution (as it is documented in the bug page) is funny. I'm opening this to ask you if you could please apply a better fix.

While the test case looks exotic, I realized that this causes bugs in an application when I use something like this:

SELECT col1, MIN(col2), MAX(col2)
FROM table
GROUP BY col1
HAVING COUNT(DISTINCT col1) > 1;

Both MIN and MAX give completely wrong results, which makes the report useless. The only workaround I was able to find is slow.

links to

Hide

Permalink

Sergei Petrunia added a comment - 2015-02-24 17:17

( Checked the source code: we have Mithun's fix, merged).

Show

Sergei Petrunia added a comment - 2015-02-24 17:17 ( Checked the source code: we have Mithun's fix, merged).