Bug #32933 missing results with order by and limit in subquery in combination with indexes
Submitted: 3 Dec 2007 15:13 Modified: 11 Jan 2008 17:04
Reporter: Timo Boehme Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:5.0.52, 5.1.22-rc-community OS:Windows
Assigned to: Georgi Kodinov CPU Architecture:Any
Tags: INDEX, limit, order by, result, size, subquery

File: Maximum allowed size is 50MB.
Description:
Privacy:

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:

[3 Dec 2007 15:19] Timo Boehme
DOS batch to create test case

Attachment: mysql-bug_subq_orderby_limit.bat (application/octet-stream, text), 834 bytes.