Bug #34751 | Inside HAVING clause subqueries with aggregates and without GROUP BY rise error | ||
---|---|---|---|
Submitted: | 21 Feb 2008 22:19 | Modified: | 8 Feb 2018 22:42 |
Reporter: | Gleb Shchepa | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.0+ | OS: | Any |
Assigned to: | Evgeny Potemkin | CPU Architecture: | Any |
[21 Feb 2008 22:19]
Gleb Shchepa
[21 Feb 2008 23:14]
MySQL Verification Team
Thank you for the bug report. Verified as described.
[22 Feb 2008 21:12]
Omer Barnir
Workaround: Use temp tables instead of 'having'
[21 Sep 2008 18:19]
Roland Bouman
I think this is a duplicate of http://bugs.mysql.com/bug.php?id=8510
[8 Feb 2018 22:42]
Roy Lyseng
Posted by developer: Fixed in 5.6 and up.