Bug #43809 | Select Distinct with Where clause generated error 1178 (42000) | ||
---|---|---|---|
Submitted: | 23 Mar 2009 19:12 | Modified: | 24 Mar 2009 13:56 |
Reporter: | Edward Huang | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Partitions | Severity: | S1 (Critical) |
Version: | Community 5.1.30 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[23 Mar 2009 19:12]
Edward Huang
[23 Mar 2009 19:18]
Sveta Smirnova
Thank you for the report. I can not repeat described behavior. Additionally version 5.1.30 is old. Please try with current version 5.1.32 and if problem still exists provide error log file.
[23 Mar 2009 19:19]
Sveta Smirnova
Additional note: in my environment I get wrong results without error message with version 5.1.30 and correct result with version 5.1.32
[24 Mar 2009 13:21]
Edward Huang
In 5.1.30 if you run this test using mysql command line, you will see the error message. I've just tested Community Edition 5.1.32 and confirmed that the problem is fixed. Switching over to 5.1.32, do we have to rebuild databases built with 5.1.30?
[24 Mar 2009 13:54]
MySQL Verification Team
Thank you for the bug report. Fixed in 5.1.32.
[24 Mar 2009 13:56]
Edward Huang
Do I need to rebuild the databases moving from 5.1.30 to 5.1.32?
[24 Mar 2009 14:45]
MySQL Verification Team
Please read the changes done since the version you have at: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html Thanks in advance.