From ca88ca16d09004430bfff91f188a94c4967a4a5a Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 11 May 2006 21:15:37 +0500 Subject: BUG#12873 - BTREE index on MEMORY table with multiple NULL values doesn't work properly Unique BTREE index on MEMORY table refuse multiple NULL values. Fixed search_flag to allow multiple null values inside unique key. heap/hp_write.c: Fixed search_flag to allow multiple null values inside unique key. mysql-test/r/heap_btree.result: Testcase for BUG#12873. mysql-test/t/heap_btree.test: Testcase for BUG#12873. --- mysql-test/t/heap_btree.test | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'mysql-test/t/heap_btree.test') diff --git a/mysql-test/t/heap_btree.test b/mysql-test/t/heap_btree.test index f1b9d290885..fb715fccefe 100644 --- a/mysql-test/t/heap_btree.test +++ b/mysql-test/t/heap_btree.test @@ -176,4 +176,12 @@ UPDATE t1 SET val=1; SELECT INDEX_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='t1'; DROP TABLE t1; +# +# BUG#12873 - BTREE index on MEMORY table with multiple NULL values doesn't +# work properly +# +CREATE TABLE t1 (a INT, UNIQUE USING BTREE(a)) ENGINE=MEMORY; +INSERT INTO t1 VALUES(NULL),(NULL); +DROP TABLE t1; + # End of 4.1 tests -- cgit v1.2.1