• Igor Babaev's avatar
    Made consistent handling of the predicates of the form · b249680f
    Igor Babaev authored
    <non-nullable datatime field> IS NULL in outer joins with
    that in inner joins.
    Previously such condition was transformed into the condition
    <non-nullable datatime field> = 0 unless the field belonged
    to an inner table of an outer join. In this case the predicate
    was interpreted as for any other field.
    Now if the field in the predicate <non-nullable datatime field> IS NULL
    belongs to an inner table of an outer join the predicate is 
    transformed into the disjunction
    <non-nullable datatime field> = 0 OR <non-nullable datatime field> IS NULL.
    This is fully compatible with the semantics of such predicates in 5.5.
    b249680f
sql_select.cc 730 KB