diff options
| author | ram@mysql.r18.ru <> | 2002-11-15 17:34:10 +0400 |
|---|---|---|
| committer | ram@mysql.r18.ru <> | 2002-11-15 17:34:10 +0400 |
| commit | 1317dd5a6340f29b5830fe7f7648ed910e919ee9 (patch) | |
| tree | d8449c565293604d659407f66a9c0157e328d099 /mysql-test/r/heap_btree.result | |
| parent | 5ce8b77301d2680abc0f1d8eb789ce434b17bef8 (diff) | |
| download | mariadb-git-1317dd5a6340f29b5830fe7f7648ed910e919ee9.tar.gz | |
test for NULL processing has been added
Diffstat (limited to 'mysql-test/r/heap_btree.result')
| -rw-r--r-- | mysql-test/r/heap_btree.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/heap_btree.result b/mysql-test/r/heap_btree.result index 12d07bf6660..a33f237a312 100644 --- a/mysql-test/r/heap_btree.result +++ b/mysql-test/r/heap_btree.result @@ -213,6 +213,20 @@ a b INSERT INTO t1 VALUES (1,3); Duplicate entry '3' for key 1 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; +a b c +1 NULL NULL +1 NULL 1 +SELECT * FROM t1 WHERE a=1 and c IS NULL; +a b c +1 NULL NULL +1 1 NULL +SELECT * FROM t1 WHERE a=1 and b IS NULL and c IS NULL; +a b c +1 NULL NULL +DROP TABLE t1; CREATE TABLE t1 (a int not null, primary key using BTREE (a)) type=heap; INSERT into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11); DELETE from t1 where a < 100; |