~maria-captains/maria/5.3

Viewing all changes in revision 3088.1.1.

  • 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.

 

expand all expand all

Show diffs side-by-side

added added

removed removed

Lines of Context: