| Bug #64855 | Stored Procedure with GROUP/ORDER BY return unpredicatable results with CASE/IF | ||
|---|---|---|---|
| Submitted: | 3 Apr 2012 14:53 | Modified: | 16 May 2012 13:20 |
| Reporter: | Patrick Mulvany (OCA) | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Stored Routines | Severity: | S2 (Serious) |
| Version: | 5.5.21, 5.6.5-m8, 5.1.64, 5.6.6, 5.5.25, 5.5.20-ndb-7.2.5 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.
To split a large file:
- On *nix platforms use the split command e.g.
split -b 50MB <my_large_archive> <my_split_archive_prefix> - On windows use WinZip or a similar utility to split the large file
[3 Apr 2012 14:53]
Patrick Mulvany
[3 Apr 2012 14:56]
Patrick Mulvany
Part 2 of Test case
Attachment: Dump-testcase1-script2.sql (application/octet-stream, text), 7.57 KiB.
[3 Apr 2012 14:56]
Patrick Mulvany
Part 3 of Test case
Attachment: Dump-testcase1-script3.sql (application/octet-stream, text), 3.26 KiB.
[3 Apr 2012 14:57]
Patrick Mulvany
Part 4 of Test case
Attachment: Dump-testcase1-script4.sql (application/octet-stream, text), 2.58 KiB.
[3 Apr 2012 14:57]
Patrick Mulvany
Part 5 of Test case
Attachment: Dump-testcase1-script5.sql (application/octet-stream, text), 3.93 KiB.
[3 Apr 2012 14:57]
Patrick Mulvany
Part 6 of Test case
Attachment: Dump-testcase1-script6.sql (application/octet-stream, text), 3.26 KiB.
[3 Apr 2012 15:29]
Patrick Mulvany
Minor update to use column names in GROUP BY rather than numeric position
Attachment: Dump-testcase1-script3.sql (application/octet-stream, text), 3.29 KiB.
[3 Apr 2012 15:29]
Patrick Mulvany
Minor update to use column names in ORDER BY rather than numeric position
Attachment: Dump-testcase1-script6.sql (application/octet-stream, text), 3.29 KiB.
[5 Apr 2012 10:20]
Patrick Mulvany
GROUP BY example
Attachment: Dump-testcase1-script7.sql (application/octet-stream, text), 2.95 KiB.
[5 Apr 2012 10:20]
Patrick Mulvany
ORDER BY example
Attachment: Dump-testcase1-script8.sql (application/octet-stream, text), 2.98 KiB.
[5 Apr 2012 10:41]
Patrick Mulvany
Example replaces scripts 3,6,7,8 covers GROUP BY/ORDER BY with CASE/IF
Attachment: Dump-testcase1-script9.sql (application/octet-stream, text), 1.86 KiB.
[18 Apr 2012 13:49]
Patrick Mulvany
MySQL 5.5.21 log showing GROUP BY issue
Attachment: mysql-5.5.21-group-by-case.log (application/octet-stream, text), 9.98 KiB.
[18 Apr 2012 13:49]
Patrick Mulvany
MySQL 5.6.4 log showing GROUP BY and CASE working
Attachment: mysql-5.6.4-group-by-case.log (application/octet-stream, text), 9.20 KiB.
[18 Apr 2012 13:55]
Patrick Mulvany
MySQL 5.5.21 log showing ORDER BY and CASE issue
Attachment: mysql-5.5.21-order-by-case.log (application/octet-stream, text), 9.34 KiB.
[18 Apr 2012 13:55]
Patrick Mulvany
MySQL 5.6.4 log showing ORDER BY and CASE issue
Attachment: mysql-5.6.4-order-by-case.log (application/octet-stream, text), 11.99 KiB.
[11 May 2012 9:37]
Patrick Mulvany
Initialisation of test case
Attachment: Dump-testcase2-script1.sql (application/octet-stream, text), 12.72 KiB.
[11 May 2012 9:37]
Patrick Mulvany
Repopulate test case
Attachment: Dump-testcase2-script3.sql (application/octet-stream, text), 3.84 KiB.
[11 May 2012 9:38]
Patrick Mulvany
Test case logs for MySQL 5.5.24
Attachment: Dump-testcase2-MySQL-5.5.24.log (application/octet-stream, text), 21.28 KiB.
[11 May 2012 9:39]
Patrick Mulvany
Test case logs for MySQL Cluster 7.2.5
Attachment: Dump-testcase2-MySQL-cluster-7.2.5.log (application/octet-stream, text), 20.15 KiB.
[28 Feb 2013 13:31]
Sveta Smirnova
test case for MTR
Attachment: bug64855.test (application/octet-stream, text), 15.81 KiB.
