diff options
| author | gluh@mysql.com/eagle.(none) <> | 2007-04-10 15:01:04 +0500 |
|---|---|---|
| committer | gluh@mysql.com/eagle.(none) <> | 2007-04-10 15:01:04 +0500 |
| commit | b80d373b6a1af56daf6f44d0455b5e5ab2ee4544 (patch) | |
| tree | 4d0de5e0bcac77725813d192e578289a08a70b97 /mysql-test/r/strict.result | |
| parent | d8e6b38ec1c07b034f8738ad64c6cbd1e23461bd (diff) | |
| download | mariadb-git-b80d373b6a1af56daf6f44d0455b5e5ab2ee4544.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'
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 |