summaryrefslogtreecommitdiff
path: root/mysql-test/r/sp-bugs.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/sp-bugs.result')
-rw-r--r--mysql-test/r/sp-bugs.result11
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