-
Committer:
Igor Babaev
-
Date:
2011-07-07 20:04:48 UTC
-
mto:
This revision was merged to the branch mainline in
revision
3090.
-
Revision ID:
igor@askmonty.org-20110707200448-uwqm5ho6fs8ippn9
Fixed LP bug #806477.
The offending query returns a wrong result set because the optimizer
erroneously eliminated the where condition evaluated it to TRUE.
The cause of this wrong transformation was that the flag maybe_null
for an inner table of the outer join was not set to TRUE after the
table had replaced the wrapping view.
Now the function SELECT_LEX::update_used_tables resets the value
of the maybe_null flag for each leaf table of the query after all
merges of views have been done.