diff options
| author | unknown <gluh@mysql.com/eagle.(none)> | 2007-04-10 15:01:04 +0500 |
|---|---|---|
| committer | unknown <gluh@mysql.com/eagle.(none)> | 2007-04-10 15:01:04 +0500 |
| commit | 5ded16c5d0830b4b84830e3e17bc63dd099492aa (patch) | |
| tree | 4d0de5e0bcac77725813d192e578289a08a70b97 /mysql-test/r/strict.result | |
| parent | 1f8dbdaf3a2bd06a87ed9fba93acb742c86fa83b (diff) | |
| download | mariadb-git-5ded16c5d0830b4b84830e3e17bc63dd099492aa.tar.gz | |
Bug#27069 set with identical elements are created(additional fix)
issue an error in strict mode
if enum|set column has duplicates members in 'create table'
mysql-test/r/strict.result:
test case
mysql-test/t/strict.test:
test case
sql/sql_table.cc:
issue an error in strict mode
if enum|set has duplicates members
Diffstat (limited to 'mysql-test/r/strict.result')
| -rw-r--r-- | mysql-test/r/strict.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/strict.result b/mysql-test/r/strict.result index 636a00a4343..f9d84df5d9f 100644 --- a/mysql-test/r/strict.result +++ b/mysql-test/r/strict.result @@ -1386,4 +1386,9 @@ ERROR 01000: Data truncated for column 'a' at row 1 insert into t1 values ('2E3x'); ERROR 01000: Data truncated for column 'a' at row 1 drop table t1; +set sql_mode='traditional'; +create table t1 (f1 set('a','a')); +ERROR HY000: Column 'f1' has duplicated value 'a' in SET +create table t1 (f1 enum('a','a')); +ERROR HY000: Column 'f1' has duplicated value 'a' in ENUM End of 5.0 tests |