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

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.

Thank you for the bug report. Please try last release 5.2.17. Thanks in advance.

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".

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.