| Bug #37138 | MySQL crashes on SQL Query | ||
|---|---|---|---|
| Submitted: | 2 Jun 2008 12:43 | Modified: | 11 Jun 2008 22:36 |
| Reporter: | Mark Kubacki | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.1.24_rc | OS: | Linux |
| Assigned to: | CPU Architecture: | Any | |
[2 Jun 2008 12:51]
MySQL Verification Team
see also bug #35298
[4 Jun 2008 20:00]
Valeriy Kravchuk
Looks like a duplicate of bug #35298. Please, check.
[11 Jun 2008 22:36]
Mark Kubacki
Duplicate, closed. Sorry.
Description: MySQL crashes on query. How to repeat: Please get the zipped database. (See below.) The query to crash MySQL is: SELECT GROUP_CONCAT(DISTINCT groups.groupID ORDER BY groups.groupID ASC SEPARATOR ',') AS groupIDs, GROUP_CONCAT(DISTINCT languages.languageID ORDER BY languages.languageID ASC SEPARATOR ',') AS languageIDs,user_option.*, user.* FROM wcf1_user user LEFT JOIN wcf1_user_to_groups groups ON (groups.userID = user.userID) LEFT JOIN wcf1_user_to_languages languages ON (languages.userID = user.userID) LEFT JOIN wcf1_user_option_value user_option ON (user_option.userID = user.userID) WHERE user.userID = 1 GROUP BY user.userID LIMIT 1 OFFSET 0