[MDEV-271] fix LP BUG#993459 Execution of PS for a query with GROUP BY returns wrong result Created: 2012-05-15 Updated: 2012-05-17 Resolved: 2012-05-17 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 5.2.12 |
| Fix Version/s: | 5.2.13 |
| Type: | Bug | Priority: | Major |
| Reporter: | Oleksandr Byelkin | Assignee: | Oleksandr Byelkin |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
https://bugs.launchpad.net/maria/+bug/993459 |
| Comments |
| Comment by Oleksandr Byelkin [ 2012-05-15 ] |
|
according to the bugreport 5.3 and above are not affected |
| Comment by Oleksandr Byelkin [ 2012-05-16 ] |
|
We do not have problem in 5.3 because we postpone execution of constant ORDER BY/GROUP BY with subqueries but in 5.2 we have special condition in remove_const() which evaluates and removes constant expression with subqueries. IMHO it will be better do not fix 5.2 and we have in fixed in 5.3 and up due to other order of OPTIMIZATION/EXECUTION for subqueries. |