Bug #93214 | LIMIT is applied before HAVING when you have a subquery | ||
---|---|---|---|
Submitted: | 15 Nov 2018 19:15 | Modified: | 17 Apr 2019 23:18 |
Reporter: | Stephen Sigwart | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S1 (Critical) |
Version: | 8.0 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[15 Nov 2018 19:15]
Stephen Sigwart
[16 Nov 2018 7:15]
MySQL Verification Team
Thank you for the bug report.
[19 Nov 2018 12:04]
Roy Lyseng
Posted by developer: Regression from Bug#25466100: Refactor const_item processing
[17 Apr 2019 23:18]
Jon Stephens
Documented fix in the MySQL 8.0.17 changelog, as follows: LIMIT was applied before HAVING in queries with subselects. Closed.