Bug #68086 | Heap tables don't use index for group by | ||
---|---|---|---|
Submitted: | 15 Jan 2013 8:41 | Modified: | 15 Jan 2013 19:22 |
Reporter: | Andy Svensson | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Memory storage engine | Severity: | S3 (Non-critical) |
Version: | 5.5.29, 5.5.30, 5.7.1 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | group-by, INDEX, optimization |
[15 Jan 2013 8:41]
Andy Svensson
[15 Jan 2013 8:44]
Andy Svensson
Reproduce
Attachment: testing.sql (application/octet-stream, text), 947 bytes.
[15 Jan 2013 8:46]
Andy Svensson
Seems like my submission got sliced. Anyway, the expected behavior is that the heap tables should use indexes for group bys too, just like ordinary tables. I added a file for the full test case to reproduce.
[15 Jan 2013 19:22]
Sveta Smirnova
Thank you for the report. Verified as described.