Bug #64445 Different execution plan alter results with Loose Index Scan with Aggregate
Submitted: 24 Feb 2012 15:10 Modified: 26 Mar 2013 6:13
Reporter: Todd Mosier Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:5.5.21, 5.5.23 OS:Linux (Ubuntu 11.10)
Assigned to: CPU Architecture:Any
Tags: aggregate functions, count, distinct, index for group by, loose index scan, regression

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:

[29 Feb 2012 19:41] Todd Mosier
dump of tm_tmp used to demonstrate the error.

Attachment: mysqldump_tm_tmp_20120229.sql (text/x-sql), 2.96 KiB.

[29 Feb 2012 19:42] Todd Mosier
dump of tm_tmp used to demonstrate the error.

Attachment: mysqldump_tm_tmp_20120229.sql (text/x-sql), 2.96 KiB.