• igor@rurik.mysql.com's avatar
    join_nested.test, join_nested.result: · 49094f58
    igor@rurik.mysql.com authored
      Added a case for bug #4976 when one of the inner tables is empty.
    select.result, join.result:
      Reversed the previous change of the erronious fix for bug #4976.
    sql_select.cc:
      The previous fix for bug 4976 was reversed as it
      erroniously converted an outer join into an innner join
      when on_expression does not refer to outer tables.
      This is not valid if inner tables return an empty set.
      Setting dependency on outer tables was added for the above cases.
      To fix the crash in the test case of bug #4976  
      a guard was added that blocks running the crashing code for
      nested outer joins.
    49094f58
join_nested.result 43.4 KB