Bug #52662 Error running an EXPLAIN statement
Submitted: 7 Apr 2010 17:20 Modified: 7 May 2010 17:47
Reporter: Fidel Clotet Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.16 OSS Beta - Revision 5249 OS:Windows (WIN 7)
Assigned to: CPU Architecture:Any

[7 Apr 2010 17:20] Fidel Clotet 
Description:
I ran the statement:

EXPLAIN select count(*) as rankForMyUid
from (select correct, count(*)
from quiz_user
group by correct
having correct>=(select correct from quiz_user where uid=$uid)) as groupsBetterOrEqualThanMyUid;

the table is:
CREATE  TABLE IF NOT EXISTS `quiz_user` (
`uid` BIGINT UNSIGNED NOT NULL ,
`participated` SMALLINT UNSIGNED NULL DEFAULT 0 ,
`correct` SMALLINT UNSIGNED NULL DEFAULT 0 ,
`wrong` SMALLINT UNSIGNED NULL DEFAULT 0 ,
`created` DATETIME NULL ,
`updated` DATETIME NULL ,
PRIMARY KEY (`uid`) ) ENGINE = InnoDB;
ALTER TABLE `test`.`quiz_user` 
ADD INDEX `correct` (`correct` ASC);

How to repeat:
It happened one time... I don't know how to repeat.
[7 Apr 2010 17:47] MySQL Verification Team 
Thank you for the bug report. Please try last release 5.2.17. Thanks in advance.
[7 May 2010 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".