diff options
author | unknown <istruewing@chilla.local> | 2007-03-27 12:46:54 +0200 |
---|---|---|
committer | unknown <istruewing@chilla.local> | 2007-03-27 12:46:54 +0200 |
commit | 5e0ce03954693c5160feeebd475b048f8b6b2497 (patch) | |
tree | b8ee8e67c2e623b6242fe216b47395b22e38168d /mysql-test/t/heap_btree.test | |
parent | e3108256e7e5118cd2097f2bfbc9987018a6b8a5 (diff) | |
parent | de3c37195691a19ac504dd60daf516219d59c503 (diff) | |
download | mariadb-git-5e0ce03954693c5160feeebd475b048f8b6b2497.tar.gz |
Merge chilla.local:/home/mydev/mysql-5.0-bug24985
into chilla.local:/home/mydev/mysql-5.1-bug24985
mysql-test/r/heap_btree.result:
Auto merged
mysql-test/t/heap_btree.test:
Auto merged
storage/heap/ha_heap.cc:
Auto merged
storage/myisam/ha_myisam.cc:
Auto merged
Diffstat (limited to 'mysql-test/t/heap_btree.test')
-rw-r--r-- | mysql-test/t/heap_btree.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/heap_btree.test b/mysql-test/t/heap_btree.test index 68aa79834fc..9484bdbce23 100644 --- a/mysql-test/t/heap_btree.test +++ b/mysql-test/t/heap_btree.test @@ -182,6 +182,23 @@ delete from t1 where a >= 2; select a from t1 order by a; drop table t1; +# +# Bug#24985 - UTF8 ENUM primary key on MEMORY using BTREE +# causes incorrect duplicate entries +# +CREATE TABLE t1 ( + c1 ENUM('1', '2'), + UNIQUE USING BTREE(c1) +) ENGINE= MEMORY DEFAULT CHARSET= utf8; +INSERT INTO t1 VALUES('1'), ('2'); +DROP TABLE t1; +CREATE TABLE t1 ( + c1 SET('1', '2'), + UNIQUE USING BTREE(c1) +) ENGINE= MEMORY DEFAULT CHARSET= utf8; +INSERT INTO t1 VALUES('1'), ('2'); +DROP TABLE t1; + --echo End of 4.1 tests # |