diff options
Diffstat (limited to 'mysql-test/r/sp-bugs.result')
-rw-r--r-- | mysql-test/r/sp-bugs.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/sp-bugs.result b/mysql-test/r/sp-bugs.result index ccccacd09a5..3db1e68321c 100644 --- a/mysql-test/r/sp-bugs.result +++ b/mysql-test/r/sp-bugs.result @@ -281,3 +281,14 @@ end| start transaction; call sp(); drop procedure sp; +# +# MDEV-11146 SP variables of the SET data type erroneously allow values with comma +# +CREATE PROCEDURE p1() +BEGIN +DECLARE a SET('a','b','c','a,b'); +SET a='a,b'; +SELECT a, a+0; +END; +$$ +ERROR 22007: Illegal set 'a,b' value found during parsing |