diff options
| author | unknown <monty@hundin.mysql.fi> | 2001-10-20 11:56:49 +0300 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2001-10-20 11:56:49 +0300 |
| commit | 440de598ee325364b89468c8bd66925956b0e66f (patch) | |
| tree | d234a7c8b4a8d73b7e4b00b64ebf5278a158a753 /mysql-test/r/null.result | |
| parent | 0625a0dab87886c92c864e60dd9464c61451760a (diff) | |
| download | mariadb-git-440de598ee325364b89468c8bd66925956b0e66f.tar.gz | |
Update test results after merge
mysql-test/r/join_outer.result:
Update test results
mysql-test/r/null.result:
Update test results
Diffstat (limited to 'mysql-test/r/null.result')
| -rw-r--r-- | mysql-test/r/null.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/null.result b/mysql-test/r/null.result index 4758304afa0..77f2c67bf05 100644 --- a/mysql-test/r/null.result +++ b/mysql-test/r/null.result @@ -40,3 +40,20 @@ insert into t1 values (null); select * from t1 where x != 0; x drop table t1; +DROP TABLE IF EXISTS t1; +CREATE TABLE t1 ( +indexed_field int default NULL, +KEY indexed_field (indexed_field) +); +INSERT INTO t1 VALUES (NULL),(NULL); +SELECT * FROM t1 WHERE indexed_field=NULL; +indexed_field +SELECT * FROM t1 WHERE indexed_field IS NULL; +indexed_field +NULL +NULL +SELECT * FROM t1 WHERE indexed_field<=>NULL; +indexed_field +NULL +NULL +DROP TABLE t1; |