Bug #11843 SELECT DISTINCT clause hangs the server
Submitted: 10 Jul 2005 13:00 Modified: 18 Jun 2006 20:53
Reporter: Werner HUYSMANS Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.2-alpha-standard OS:Linux (LINUX Fedora Core 3)
Assigned to: CPU Architecture:Any

[10 Jul 2005 13:00] Werner HUYSMANS 
Description:
I'm running 
Your MySQL connection id is 41 to server version: 5.0.2-alpha-standard

When I run the following query:
SELECT DISTINCT TASKNUM AS id, TASKNUM AS text FROM WOCONTROL ORDER BY TASKNUM ASC
The system hangs ...

The alternative I use now, is SELECT ... GROUP BY TASKNUM

How to repeat:
Rerun this query

Suggested fix:
I never notice this error in the 4 Version ?
[10 Jul 2005 13:02] Aleksey Kishkin 
could you please to provide here output of 'explain'?
And table definitions that we can try to reproduce this bug.
[10 Aug 2005 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".
[18 May 2006 20:53] Valeriy Kravchuk 
Please, try to repeat with a newer version of MySQL server, 5.0.21, and inform about the results.
[18 Jun 2006 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".