• Igor Babaev's avatar
    Fixed LP bug #806477. · e55e78ee
    Igor Babaev authored
    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.
    
     
    e55e78ee
derived_view.test 14 KB