diff options
| author | istruewing@chilla.local <> | 2007-03-27 21:19:25 +0200 |
|---|---|---|
| committer | istruewing@chilla.local <> | 2007-03-27 21:19:25 +0200 |
| commit | e5f50abcd96ed9ae01ce370d9fcc864ce2f4b2d1 (patch) | |
| tree | 4cb4357a7e7a91336f31c5d4d2495e13c6f206bd /mysql-test/t/heap_btree.test | |
| parent | a009d2dd6fb48ab4c2a4c6ecae3bf7f7c0154f53 (diff) | |
| parent | 01be61e30770f64b0095a6aaf9b55db2369f1da8 (diff) | |
| download | mariadb-git-e5f50abcd96ed9ae01ce370d9fcc864ce2f4b2d1.tar.gz | |
Merge bk-internal.mysql.com:/home/bk/mysql-5.0-engines
into chilla.local:/home/mydev/mysql-5.0-bug24985
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 2dd5f64014a..af8f9d9c9e8 100644 --- a/mysql-test/t/heap_btree.test +++ b/mysql-test/t/heap_btree.test @@ -196,6 +196,23 @@ UPDATE t1 SET c2= c2 + 1 WHERE c1 = 'A'; SELECT * FROM t1; 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 # |