diff options
| author | unknown <ram@mysql.r18.ru> | 2002-11-15 17:34:10 +0400 |
|---|---|---|
| committer | unknown <ram@mysql.r18.ru> | 2002-11-15 17:34:10 +0400 |
| commit | ecd4ac2a3c16db45653b74e8b73dcc7815fd42f5 (patch) | |
| tree | d8449c565293604d659407f66a9c0157e328d099 /mysql-test/t/heap_btree.test | |
| parent | 87db341dd50ab6ead3593d4b25c20a8a280d1478 (diff) | |
| download | mariadb-git-ecd4ac2a3c16db45653b74e8b73dcc7815fd42f5.tar.gz | |
test for NULL processing has been added
Diffstat (limited to 'mysql-test/t/heap_btree.test')
| -rw-r--r-- | mysql-test/t/heap_btree.test | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/t/heap_btree.test b/mysql-test/t/heap_btree.test index 3dd22f2da03..5c0002fede4 100644 --- a/mysql-test/t/heap_btree.test +++ b/mysql-test/t/heap_btree.test @@ -137,6 +137,13 @@ SELECT * FROM t1 WHERE b<=>NULL; INSERT INTO t1 VALUES (1,3); DROP TABLE t1; +CREATE TABLE t1 (a int, b int, c int, key using BTREE (a, b, c)) type=heap; +INSERT INTO t1 VALUES (1, NULL, NULL), (1, 1, NULL), (1, NULL, 1); +SELECT * FROM t1 WHERE a=1 and b IS NULL; +SELECT * FROM t1 WHERE a=1 and c IS NULL; +SELECT * FROM t1 WHERE a=1 and b IS NULL and c IS NULL; +DROP TABLE t1; + # # Test when deleting all rows # |