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 | daafa8db5049da5a8e3c51edb7cb5b7f36dbc73f (patch) | |
| tree | 998601644441d26cc8a548d4f2e086978a15feea /mysql-test/t | |
| parent | 6c6ae10e7532e3630396160ccb41f79ce8ce001c (diff) | |
| download | mariadb-git-daafa8db5049da5a8e3c51edb7cb5b7f36dbc73f.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/t')
| -rw-r--r-- | mysql-test/t/join.test | 1 |
1 files changed, 1 insertions, 0 deletions
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; # |