Bug #10373 MySQL Server Restarted
Submitted: 5 May 2005 2:25 Modified: 5 Jun 2005 9:38
Reporter: Sumedha Wijeratne Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.1 OS:Linux (Linux)
Assigned to: Assigned Account CPU Architecture:Any

[5 May 2005 2:25] Sumedha Wijeratne 
Description:
The MySQL service repeatedly restarted on Linux when issued a SQL Query including a 'NOT IN' subquery. 

How to repeat:
Select F1, F2, F3, F4, f5, f6, f7, f8 
From T1, t2
Where F1 = v0 and F2 = v1 and f5 = v2
and F11 Not In (Select f12 From t2 Where f5 = v2 and f13 = v3)
[5 May 2005 9:38] Hartmut Holzgraefe 
Can you please add dump files for the two tables used in the query so that 
we can try to reproduce the problem? And please add the exact version of
4.1 you are using?
[5 Jun 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".