diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-03-12 11:40:37 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-03-12 11:40:37 +0400 |
| commit | e91bc2e91d649d4650fc4d8961edc3280d1203fe (patch) | |
| tree | ce7b3e77ea1a132e2f20edb0fd7ea58fe9c9a3ff /mysql-test/t/null.test | |
| parent | 80f03abcca0d902a876d10e6c1dc8c4c6d3b2bfa (diff) | |
| download | mariadb-git-e91bc2e91d649d4650fc4d8961edc3280d1203fe.tar.gz | |
MDEV-7759 NULLIF(x,y) is not equal to CASE WHEN x=y THEN NULL ELSE x END
Diffstat (limited to 'mysql-test/t/null.test')
| -rw-r--r-- | mysql-test/t/null.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/null.test b/mysql-test/t/null.test index 4af17490488..65a45b9a21c 100644 --- a/mysql-test/t/null.test +++ b/mysql-test/t/null.test @@ -850,5 +850,25 @@ DROP TABLE t2; DROP TABLE t1; --echo # +--echo # MDEV-7759 NULLIF(x,y) is not equal to CASE WHEN x=y THEN NULL ELSE x END +--echo # +CREATE TABLE t1 (a YEAR); +INSERT INTO t1 VALUES (2010),(2020); +SELECT * FROM t1 WHERE a=2010 AND NULLIF(10.1,a) IS NULL; +EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=2010 AND NULLIF(10.1,a) IS NULL; +SELECT * FROM t1 WHERE a=2010 AND CASE WHEN 10.1=a THEN NULL ELSE 10.1 END IS NULL; +EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=2010 AND CASE WHEN 10.1=a THEN NULL ELSE 10.1 END IS NULL; +DROP TABLE t1; + +--echo # Two warnings expected +CREATE TABLE t1 AS SELECT + NULLIF(TIMESTAMP'2001-01-01 00:00:00',1) AS a, + CASE WHEN TIMESTAMP'2001-01-01 00:00:00'=1 THEN NULL + ELSE TIMESTAMP'2001-01-01 00:00:00' + END AS b; +DROP TABLE t1; + + +--echo # --echo # End of 10.1 tests --echo # |