Bug #7960 | Lost Connection during SQL Select | ||
---|---|---|---|
Submitted: | 17 Jan 2005 16:17 | Modified: | 19 Jan 2005 19:26 |
Reporter: | Terry Long | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.0.0-alpha | OS: | Windows (Windows XP) |
Assigned to: | CPU Architecture: | Any |
[17 Jan 2005 16:17]
Terry Long
[18 Jan 2005 22:00]
Terry Long
Simplified Select to repeat error: Will CRASH (with order by on a date field in subquery) SELECT p1.prh_receiver, p1.prh_part, ( SELECT pp.prh_pur_cost FROM prh_hist pp WHERE pp.prh_part = p1.prh_part ORDER BY pp.prh_rcp_date DESC LIMIT 1 )fld1 FROM prh_hist p1 WHERE p1.site_code LIKE '0760' WILL NOT CRASH (with an order by char field in the subquery) SELECT p1.prh_receiver, p1.prh_part, ( SELECT pp.prh_pur_cost FROM prh_hist pp WHERE pp.prh_part = p1.prh_part ORDER BY pp.prh_part DESC LIMIT 1 )fld1 FROM prh_hist p1 WHERE p1.site_code LIKE '0760'
[19 Jan 2005 19:26]
Jorge del Conde
Thank you for taking the time to report a problem. Unfortunately you are not using a current version of the product your reported a problem with -- the problem might already be fixed. Please download a new version from http://www.mysql.com/downloads/ If you are able to reproduce the bug with one of the latest versions, please change the version on this bug report to the version you tested and change the status back to "Open". Again, thank you for your continued support of MySQL.