• igor@olga.mysql.com's avatar
    Fixed bug #24345. · 08369f4b
    igor@olga.mysql.com authored
    This bug appeared after the patch for bug 21390 that had added some code
    to handle outer joins with no matches after substitution of a const
    table in an efficient way. That code as it is cannot be applied to the case
    of nested outer join operations. Being applied to the queries with
    nested outer joins the code can cause crashes or wrong result sets.
    The fix blocks row substitution for const inner tables of an outer join
    if the inner operand is not a single table.  
    08369f4b
join_nested.test 26.9 KB