diff options
| author | unknown <bar@mysql.com> | 2004-10-26 10:41:14 +0500 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2004-10-26 10:41:14 +0500 |
| commit | dc734355e6c6f5563b4a80b23efce660d66c93c7 (patch) | |
| tree | e68c02bde2addf82714c990d39e19946680ea455 /mysql-test | |
| parent | 52da7eb858bc680280cce9c67a8ebcc25f3985ba (diff) | |
| download | mariadb-git-dc734355e6c6f5563b4a80b23efce660d66c93c7.tar.gz | |
- Check ENUM/SET duplicate values taking in account charset/collation.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/ctype_sjis.result | 13 | ||||
| -rw-r--r-- | mysql-test/r/type_enum.result | 2 | ||||
| -rw-r--r-- | mysql-test/t/ctype_sjis.test | 10 |
3 files changed, 23 insertions, 2 deletions
diff --git a/mysql-test/r/ctype_sjis.result b/mysql-test/r/ctype_sjis.result index 26a45dd28e8..b0edbed1a41 100644 --- a/mysql-test/r/ctype_sjis.result +++ b/mysql-test/r/ctype_sjis.result @@ -47,3 +47,16 @@ select hex(a) from t1; hex(a) 878A drop table t1; +create table t1(c enum(0x9353,0x9373) character set sjis); +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c` enum('“S','“s') character set sjis default NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +insert into t1 values (0x9353); +insert into t1 values (0x9373); +select hex(c) from t1; +hex(c) +9353 +9373 +drop table t1; diff --git a/mysql-test/r/type_enum.result b/mysql-test/r/type_enum.result index 27539953aa9..da85ffe6495 100644 --- a/mysql-test/r/type_enum.result +++ b/mysql-test/r/type_enum.result @@ -1678,8 +1678,6 @@ a int(11) YES 1 b enum('value','öäü_value','ÊÃÕ') value drop table t1; CREATE TABLE t1 (c enum('a', 'A') BINARY); -Warnings: -Note 1291 Column 'c' has duplicated value 'a' in ENUM INSERT INTO t1 VALUES ('a'),('A'); SELECT * FROM t1; c diff --git a/mysql-test/t/ctype_sjis.test b/mysql-test/t/ctype_sjis.test index 68f4f7010e0..c910812ef8a 100644 --- a/mysql-test/t/ctype_sjis.test +++ b/mysql-test/t/ctype_sjis.test @@ -41,3 +41,13 @@ create table t1 (a char(10) character set sjis); insert into t1 values (0x878A); select hex(a) from t1; drop table t1; + +# +# Bug #6206 ENUMs are not case sensitive even if declared BINARY +# +create table t1(c enum(0x9353,0x9373) character set sjis); +show create table t1; +insert into t1 values (0x9353); +insert into t1 values (0x9373); +select hex(c) from t1; +drop table t1; |