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/t/strict.test | |
| 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/t/strict.test')
| -rw-r--r-- | mysql-test/t/strict.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/strict.test b/mysql-test/t/strict.test index 5e4d956527b..1792c0fccbc 100644 --- a/mysql-test/t/strict.test +++ b/mysql-test/t/strict.test @@ -1249,4 +1249,13 @@ insert into t1 values ('2000a'); insert into t1 values ('2E3x'); drop table t1; +# +# Bug#27069 set with identical elements are created +# +set sql_mode='traditional'; +--error 1291 +create table t1 (f1 set('a','a')); +--error 1291 +create table t1 (f1 enum('a','a')); + --echo End of 5.0 tests |