diff options
author | Vladislav Vaintroub <wlad@montyprogram.com> | 2012-05-02 16:53:02 +0200 |
---|---|---|
committer | Vladislav Vaintroub <wlad@montyprogram.com> | 2012-05-02 16:53:02 +0200 |
commit | 26fcc55017d0f199c06688e09b21b7b00027171d (patch) | |
tree | 0e2fab1906d00d2926abf47b74d266c7cb4351dd /mysql-test/r/type_date.result | |
parent | feb4776ecf75c34059789a1d642bd778babec98c (diff) | |
download | mariadb-git-26fcc55017d0f199c06688e09b21b7b00027171d.tar.gz |
LP993103: Wrong result with LAST_DAY('0000-00-00 00:00:00')IS NULL in WHERE condition
Fix is to set maybe_null flag for Item_func_last_day.
Diffstat (limited to 'mysql-test/r/type_date.result')
-rw-r--r-- | mysql-test/r/type_date.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/type_date.result b/mysql-test/r/type_date.result index dab1d78ba27..e0a75174f71 100644 --- a/mysql-test/r/type_date.result +++ b/mysql-test/r/type_date.result @@ -21,6 +21,12 @@ name cdate note name1 1998-01-01 note01 name2 1998-01-01 note01 drop table t1,t2; +CREATE TABLE t1(a INT); +INSERT INTO t1 VALUES(1); +SELECT * FROM t1 WHERE LAST_DAY('0000-00-00 00:00:00') IS NULL; +a +1 +DROP TABLE t1; CREATE TABLE t1 ( datum DATE ); INSERT INTO t1 VALUES ( "2000-1-1" ); INSERT INTO t1 VALUES ( "2000-1-2" ); |