Bug #674 | DISTINCT ... DESC LIMIT cause "Lost connection..." | ||
---|---|---|---|
Submitted: | 18 Jun 2003 12:14 | Modified: | 25 Jun 2003 5:16 |
Reporter: | Alexey Stroganov | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 4.0.13/14, 4.1.1 | OS: | Linux (Linux) |
Assigned to: | Alexey Botchkov | CPU Architecture: | Any |
[18 Jun 2003 12:14]
Alexey Stroganov
[19 Jun 2003 2:50]
Alexander Keremidarski
Query result is meaningless, but still it is crashing Bug. Here is shortest query which triggers it: SELECT DISTINCT SUM(out)/(SUM(rin)+1) as 'prod' FROM htmls GROUP BY rin; sql_select.cc:4110 if (!(key_part_info= (KEY_PART_INFO*) sql_calloc((keyinfo->key_parts)*sizeof(KEY_PART_INFO)))) sql_calloc() is called with size=4294967272 Before that at sql_select.cc:4027 keyinfo=param->keyinfo;
[25 Jun 2003 5:16]
Alexey Botchkov
Thank you for your bug report. This issue has been fixed in the latest development tree for that product. You can find more information about accessing our development trees at http://www.mysql.com/doc/en/Installing_source_tree.html