diff options
| author | unknown <monty@hundin.mysql.fi> | 2002-05-07 19:08:56 +0300 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2002-05-07 19:08:56 +0300 |
| commit | 9a6691965bfbbd3689d2d0355d12cd6a92ebb5ad (patch) | |
| tree | 998601644441d26cc8a548d4f2e086978a15feea /mysql-test | |
| parent | 804a9307464b10df5bd0a96dbdd212f6a632d888 (diff) | |
| download | mariadb-git-9a6691965bfbbd3689d2d0355d12cd6a92ebb5ad.tar.gz | |
Fix for ISNULL()
Docs/manual.texi:
Chagnelog
mysql-test/r/join.result:
New tests for IS NULL
mysql-test/t/join.test:
New tests for IS NULL
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/join.result | 3 | ||||
| -rw-r--r-- | mysql-test/t/join.test | 1 |
2 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/join.result b/mysql-test/r/join.result index c99c63245dd..39331fc68e4 100644 --- a/mysql-test/r/join.result +++ b/mysql-test/r/join.result @@ -27,6 +27,9 @@ d d 0000-00-00 NULL d 0000-00-00 +d +2001-08-01 +0000-00-00 COUNT(t1.Title) 1 COUNT(t1.Title) diff --git a/mysql-test/t/join.test b/mysql-test/t/join.test index 9db520a5edf..d31db5c4837 100644 --- a/mysql-test/t/join.test +++ b/mysql-test/t/join.test @@ -120,6 +120,7 @@ CREATE TABLE t2 (d DATE NOT NULL); INSERT INTO t1 (d) VALUES ('2001-08-01'),('0000-00-00'); SELECT * FROM t1 LEFT JOIN t2 USING (d) WHERE t2.d IS NULL; SELECT * from t1 WHERE t1.d IS NULL; +SELECT * FROM t1 WHERE 1/0 IS NULL; DROP TABLE t1,t2; # |