From 4af4e1e704f224d95cacc465e9cffc59a52aae7e Mon Sep 17 00:00:00 2001 From: unknown Date: Wed, 29 Mar 2006 19:52:26 +0500 Subject: 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 --- mysql-test/r/create.result | 2 ++ mysql-test/t/create.test | 6 ++++++ 2 files changed, 8 insertions(+) (limited to 'mysql-test') 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 -- cgit v1.2.1