Bug #20643 undefined WHERE on JOIN column crashes server
Submitted: 22 Jun 2006 23:02 Modified: 26 Jul 2006 11:59
Reporter: Gunar Werner Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.18 OS:
Assigned to: MySQL Verification Team CPU Architecture:Any

[22 Jun 2006 23:02] Gunar Werner 
Description:
Server crashes if incorrect WHERE condition for a column used as definition for a JOIN is provided.

How to repeat:
SELECT table1.id
FROM table1
LEFT JOIN table2
USING (id)
WHERE table2.id IS NULL

Suggested fix:
Because the SQL statement is wrong, the parser should throw an error, so that the server doesn't crash.
[22 Jun 2006 23:18] MySQL Verification Team 
Thank you for the bug report. Could you please provide the create
table definition and OS too . Thanks in advance.
[22 Jun 2006 23:18] MySQL Verification Team 
Thank you for the bug report. Could you please provide the create
table definition and OS too . Thanks in advance.
[26 Jun 2006 11:59] MySQL Verification Team 
Thank you for the feedback. Please re-open this bug report when you are
able for to provide a repeatable test case on our side.
Thanks in advance.
[26 Jul 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".