Bug #53442 EXPLAIN doesn't detec an index-covered query with InnoDB

• Submitted: 5 May 2010 16:10
• Modified: 5 May 2010 22:44
• Reporter: Dor Cohen
• Status: Can't repeat
• Category: MySQL Server: Optimizer
• Severity: S3 (Non-critical)
• Version: 5.1.46 - community
• OS: Windows
• CPU Architecture: Any
• Tags: explain, index-covered, innodb, Using index

[5 May 2010 16:10] Dor Cohen

Description:
EXPLAIN clause doesn't show "Using index" in the `Extra` column when appropriate, for InnoDB.

Tested on Windows XP Professional SP3.

How to repeat:
Please execute the attached SQL file and review the results that I received in the attached plain text file.

Suggested fix:
Using FORCE INDEX.

[5 May 2010 16:11] Dor Cohen

The SQL script file

Attachment: so.sql (application/octet-stream, text), 2.17 KiB.

[5 May 2010 16:11] Dor Cohen

The results

Attachment: so.txt (text/plain), 16.92 KiB.

[5 May 2010 22:42] MySQL Verification Team

Results on today source

Attachment: so-source.txt (text/plain), 7.78 KiB.

[5 May 2010 22:44] MySQL Verification Team

Thank you for the bug report, not repeatable with today source server, see attached file.