summaryrefslogtreecommitdiff
path: root/mysql-test/t/create.test
diff options
context:
space:
mode:
authorvva@eagle.mysql.r18.ru <>2004-03-13 23:13:31 +0400
committervva@eagle.mysql.r18.ru <>2004-03-13 23:13:31 +0400
commit5bada5ee99c18c5b2d602012c41900ffff4c9a33 (patch)
treee13473a9ff7e860a9284023ca3cd4d3aaf7c632c /mysql-test/t/create.test
parent001ad875547e9551958f9696ecb13544606ef895 (diff)
downloadmariadb-git-5bada5ee99c18c5b2d602012c41900ffff4c9a33.tar.gz
fixed bug #1427 "enum allows duplicate values in the list"
Diffstat (limited to 'mysql-test/t/create.test')
-rw-r--r--mysql-test/t/create.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test
index 70fa4173c76..516facb029e 100644
--- a/mysql-test/t/create.test
+++ b/mysql-test/t/create.test
@@ -347,6 +347,15 @@ describe t2;
drop table t1, t2;
#
+# test for bug #1427 "enum allows duplicate values in the list"
+#
+
+create table t1(cenum enum('a'), cset set('b'));
+create table t2(cenum enum('a','a'), cset set('b','b'));
+create table t3(cenum enum('a','A','a','c','c'), cset set('b','B','b','d','d'));
+drop table t1, t2, t3;
+
+#
# Bug #1209
#