• Sergey Petrunya's avatar
    BUG#803457: Wrong result with semijoin + view + outer join in maria-5.3-subqueries-mwl90 · 56a23357
    Sergey Petrunya authored
    (This is not a real fix for this bug, even though it makes it to no longer repeat)
    - Semi-join subquery predicates, i.e. ... WHERE outer_expr IN (SELECT ...) may have null-rejecting properties,
      may allow to convert outer joins into inner.
    - When convert_subq_to_sj() injected IN-equality into parent's WHERE/ON clause, it didn't call 
      $new_cond->top_level_item(), which would cause null-rejecting properties to be lost.
    - Fixed, now the mentioned outer-to-inner conversion will really take place.
    56a23357
subselect_sj2_jcl6.result 23.6 KB