• unknown's avatar
    Fix for bug #8143: A date with value 0 is treated as a NULL value · 16878843
    unknown authored
    
    mysql-test/r/delete.result:
      Fix for bug #8143: A date with value 0 is treated as a NULL value
        - test result
    mysql-test/t/delete.test:
      Fix for bug #8143: A date with value 0 is treated as a NULL value
        - test case
    sql/sql_delete.cc:
      Fix for bug #8143: A date with value 0 is treated as a NULL value
        - during SELECT queries processing we convert 'date[time]_field is null' 
          conditions into 'date[time]_field = 0000-00-00[ 00:00:00]' for not null 
          DATE and DATETIME fields. To be consistent, we have to do the same for DELETE
          queries. So we should call remove_eq_conds() in the mysql_delete() as well.
          Also it may simplify and speed up DELETE queries execution.
    16878843
delete.test 5.01 KB