• Sergey Petrunya's avatar
    BUG#884184: Wrong result with RIGHT JOIN + derived_merge · f2b6f4e3
    Sergey Petrunya authored
    - Make eliminate_tables_for_list() take into account that it is not possible
      to eliminate a table if it is used in the upper-side ON expressions. Example:
    
        xxx JOIN (t1 LEFT JOIN t2 ON cond ) ON func(t2.columns)
    
      Here it would eliminate t2 which is not possible because of use of t2.columns.
    f2b6f4e3
opt_table_elimination.cc 55.6 KB