Bug #37055 sub query with in condition takes long time and it hangs
Submitted: 29 May 2008 6:09 Modified: 30 Jun 2008 15:29
Reporter: Venkat Loganathan Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: DML Severity:S2 (Serious)
Version:5.0.18 OS:Linux
Assigned to: CPU Architecture:Any
Tags: IN, SELECT

[29 May 2008 6:09] Venkat Loganathan 
Description:
select * from mantis_bug_history_table where id in (
select max(hist.id)
from mantis_bug_history_table hist
where hist.field_name like '3rd Part%Org%'
group by  hist.bug_id
order by hist.id desc
)

Above query hanges after some time and never display any result

How to repeat:
Change the table name and column.
[30 May 2008 15:29] MySQL Verification Team 
Thank you for the bug report. That server is quite older could you please upgrade and if you still get the same result please provide a dump file with data. Thanks in advance.
[30 Jun 2008 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".