summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <gluh@eagle.intranet.mysql.r18.ru>2006-03-29 19:52:26 +0500
committerunknown <gluh@eagle.intranet.mysql.r18.ru>2006-03-29 19:52:26 +0500
commit4af4e1e704f224d95cacc465e9cffc59a52aae7e (patch)
tree7fad6f415c7231b1eeb99553dcf4cbaa4218a58e /mysql-test
parenta8c9bbd4bea5587f930e6029d26e1aac6bbef21c (diff)
downloadmariadb-git-4af4e1e704f224d95cacc465e9cffc59a52aae7e.tar.gz
Fix for bug#15316 SET value having comma not correctly handled
disallow the use of comma in SET members mysql-test/r/create.result: Fix for bug#15316 SET value having comma not correctly handled test case mysql-test/t/create.test: Fix for bug#15316 SET value having comma not correctly handled test case
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