diff options
| author | unknown <istruewing@chilla.local> | 2007-03-27 10:54:37 +0200 |
|---|---|---|
| committer | unknown <istruewing@chilla.local> | 2007-03-27 10:54:37 +0200 |
| commit | 42422d0e62c680cb4b1d65f830f2111aa1a9302f (patch) | |
| tree | 6727921791dd6b4d238f363aa5f6dd0523671db7 /mysql-test/t/heap_btree.test | |
| parent | 578d29d6f342a8c3b3b3dfa04b8ccee5bc4b4879 (diff) | |
| parent | 1fd0ba8909465f70c3b4e5d4dea4dc56b132896a (diff) | |
| download | mariadb-git-42422d0e62c680cb4b1d65f830f2111aa1a9302f.tar.gz | |
Merge chilla.local:/home/mydev/mysql-4.1-bug24985
into chilla.local:/home/mydev/mysql-5.0-bug24985
mysql-test/r/heap_btree.result:
Auto merged
sql/ha_heap.cc:
Auto merged
mysql-test/t/heap_btree.test:
Bug#24985 - UTF8 ENUM primary key on MEMORY using BTREE
causes incorrect duplicate entries
Manual merge from 4.1
Diffstat (limited to 'mysql-test/t/heap_btree.test')
| -rw-r--r-- | mysql-test/t/heap_btree.test | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/heap_btree.test b/mysql-test/t/heap_btree.test index 03ba8661a3c..14b1779bd1a 100644 --- a/mysql-test/t/heap_btree.test +++ b/mysql-test/t/heap_btree.test @@ -204,4 +204,22 @@ CREATE TABLE t1 (a INT, UNIQUE USING BTREE(a)) ENGINE=MEMORY; INSERT INTO t1 VALUES(NULL),(NULL); 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 --echo End of 5.0 tests |