Bug #8974 | Wrong query results in OUTER JOIN + WHERE with conditions on inner table | ||
---|---|---|---|
Submitted: | 5 Mar 2005 9:20 | Modified: | 8 Mar 2005 2:04 |
Reporter: | Sergey Petrunya | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.0-bk, 4.1-bk | OS: | |
Assigned to: | CPU Architecture: | Any |
[5 Mar 2005 9:20]
Sergey Petrunya
[5 Mar 2005 12:34]
Sergei Golubchik
Why do you think it's a bug ? All rows satisfy WHERE clause - in particular "or t61.b is null" part. I'd say results are correct.
[8 Mar 2005 2:04]
Sergey Petrunya
Pasted wrong queries into the bug report form, and now can't replicate the problem.