diff options
| author | ramil/ram@ramil.myoffice.izhnet.ru <> | 2007-10-15 09:41:30 +0500 |
|---|---|---|
| committer | ramil/ram@ramil.myoffice.izhnet.ru <> | 2007-10-15 09:41:30 +0500 |
| commit | 981ebebf4edceeba6a0dd68ca0a4311dea1cdc11 (patch) | |
| tree | 42dc2c0741d68af0adabbdad1742a6851d16d4a8 /mysql-test/r/heap_btree.result | |
| parent | 8402823d412d8748b88367185b6db0084787855c (diff) | |
| parent | b4b7cf2a95f96892d5ae14608ca52107528b2b7d (diff) | |
| download | mariadb-git-981ebebf4edceeba6a0dd68ca0a4311dea1cdc11.tar.gz | |
Merge mysql.com:/home/ram/work/b30885/b30885.5.0
into mysql.com:/home/ram/work/b30885/b30885.5.1
Diffstat (limited to 'mysql-test/r/heap_btree.result')
| -rw-r--r-- | mysql-test/r/heap_btree.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/heap_btree.result b/mysql-test/r/heap_btree.result index ab4b892170a..44241563dda 100644 --- a/mysql-test/r/heap_btree.result +++ b/mysql-test/r/heap_btree.result @@ -321,4 +321,12 @@ DROP TABLE t1; CREATE TABLE t1 (a INT, UNIQUE USING BTREE(a)) ENGINE=MEMORY; INSERT INTO t1 VALUES(NULL),(NULL); DROP TABLE t1; +create table t1(a varchar(255), b varchar(255), +key using btree (a,b)) engine=memory; +insert into t1 values (1, 1), (3, 3), (2, 2), (NULL, 1), (NULL, NULL), (0, 0); +select * from t1 where a is null; +a b +NULL NULL +NULL 1 +drop table t1; End of 5.0 tests |