• Ramil Kalimullin's avatar
    Fix for bug#37526: asymertic operator <=> in trigger · 835f3528
    Ramil Kalimullin authored
    Problem: <=> operator may return wrong results 
    comparing NULL and a DATE/DATETIME/TIME value.
    
    Fix: properly check NULLs.
    
    
    mysql-test/r/type_datetime.result:
      Fix for bug#37526: asymertic operator <=> in trigger
        - test result.
    mysql-test/t/type_datetime.test:
      Fix for bug#37526: asymertic operator <=> in trigger
        - test case.
    sql/item_cmpfunc.cc:
      Fix for bug#37526: asymertic operator <=> in trigger
        - if is_nulls_eq is TRUE Arg_comparator::compare_datetime() 
      should return 1 only if both arguments are NULL.
    835f3528
item_cmpfunc.cc 129 KB