diff options
| author | unknown <ramil/ram@ramil.myoffice.izhnet.ru> | 2007-10-15 09:41:30 +0500 |
|---|---|---|
| committer | unknown <ramil/ram@ramil.myoffice.izhnet.ru> | 2007-10-15 09:41:30 +0500 |
| commit | 0de643806099112a6078dcf27474242567bfcac8 (patch) | |
| tree | 42dc2c0741d68af0adabbdad1742a6851d16d4a8 /mysql-test/t/heap_btree.test | |
| parent | 7c1098292d721093eebaa1c39b977d43030025d7 (diff) | |
| parent | 01b3b7785b6d8cf7190594dbcee235771b9a4092 (diff) | |
| download | mariadb-git-0de643806099112a6078dcf27474242567bfcac8.tar.gz | |
Merge mysql.com:/home/ram/work/b30885/b30885.5.0
into mysql.com:/home/ram/work/b30885/b30885.5.1
mysql-test/r/heap_btree.result:
Auto merged
mysql-test/t/heap_btree.test:
Auto merged
storage/heap/hp_hash.c:
the code was changed to use bitmaps instead of key length, so ul
Diffstat (limited to 'mysql-test/t/heap_btree.test')
| -rw-r--r-- | mysql-test/t/heap_btree.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/heap_btree.test b/mysql-test/t/heap_btree.test index 0e8cc71dab5..204b820970c 100644 --- a/mysql-test/t/heap_btree.test +++ b/mysql-test/t/heap_btree.test @@ -235,5 +235,14 @@ CREATE TABLE t1 (a INT, UNIQUE USING BTREE(a)) ENGINE=MEMORY; INSERT INTO t1 VALUES(NULL),(NULL); DROP TABLE t1; +# +# Bug #30885: MEMORY returns incorrect data if BTREE index is used for NULL lookup +# +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; +drop table t1; + --echo End of 5.0 tests |