summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorgluh@eagle.intranet.mysql.r18.ru <>2006-03-29 19:52:26 +0500
committergluh@eagle.intranet.mysql.r18.ru <>2006-03-29 19:52:26 +0500
commit2545c7d414b45edf890052a63ccec1594fa89bfc (patch)
tree7fad6f415c7231b1eeb99553dcf4cbaa4218a58e /mysql-test
parent4886c53fbb3850c3775e67508a81cd083e5651a1 (diff)
downloadmariadb-git-2545c7d414b45edf890052a63ccec1594fa89bfc.tar.gz
Fix for bug#15316 SET value having comma not correctly handled
disallow the use of comma in SET members
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/create.result2
-rw-r--r--mysql-test/t/create.test6
2 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result
index 6fe148adce5..aa25c55f394 100644
--- a/mysql-test/r/create.result
+++ b/mysql-test/r/create.result
@@ -699,3 +699,5 @@ t2 CREATE TABLE `t2` (
`a2` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
drop table t1, t2;
+create table t1(a set("a,b","c,d") not null);
+ERROR HY000: Illegal set 'a,b' value found during parsing
diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test
index 7799200eaa0..57b16a13c01 100644
--- a/mysql-test/t/create.test
+++ b/mysql-test/t/create.test
@@ -603,4 +603,10 @@ show create table t2;
drop table t1, t2;
+#
+# Bug #15316 SET value having comma not correctly handled
+#
+--error 1105
+create table t1(a set("a,b","c,d") not null);
+
# End of 4.1 tests