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/r/heap_btree.result | 3 +++ 1 file changed, 3 insertions(+) (limited to 'mysql-test/r/heap_btree.result') diff --git a/mysql-test/r/heap_btree.result b/mysql-test/r/heap_btree.result index b63eaf7e48c..4b05e8f44e1 100644 --- a/mysql-test/r/heap_btree.result +++ b/mysql-test/r/heap_btree.result @@ -256,3 +256,6 @@ SELECT INDEX_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=DATABASE() INDEX_LENGTH 21 DROP TABLE t1; +CREATE TABLE t1 (a INT, UNIQUE USING BTREE(a)) ENGINE=MEMORY; +INSERT INTO t1 VALUES(NULL),(NULL); +DROP TABLE t1; -- cgit v1.2.1