summaryrefslogtreecommitdiff
path: root/mysql-test/main/keywords.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/keywords.test')
-rw-r--r--mysql-test/main/keywords.test36
1 files changed, 36 insertions, 0 deletions
diff --git a/mysql-test/main/keywords.test b/mysql-test/main/keywords.test
index 4ac8f56afc5..a745aada106 100644
--- a/mysql-test/main/keywords.test
+++ b/mysql-test/main/keywords.test
@@ -259,3 +259,39 @@ DROP TABLE raise;
CREATE TABLE reuse (reuse int);
DROP TABLE reuse;
+
+
+--echo #
+--echo # MDEV-17363 Compressed columns cannot be restored from dump
+--echo # COMPRESSED is not valid as an SP label any more
+--echo # but is still valid as an SP variable name.
+--echo #
+
+DELIMITER $$;
+--error ER_PARSE_ERROR
+BEGIN NOT ATOMIC
+compressed:
+ BEGIN
+ SELECT 1 AS a;
+ END;
+END
+$$
+DELIMITER ;$$
+
+DELIMITER $$;
+BEGIN NOT ATOMIC
+`compressed`:
+ BEGIN
+ SELECT 1 AS a;
+ END;
+END
+$$
+DELIMITER ;$$
+
+DELIMITER $$;
+BEGIN NOT ATOMIC
+ DECLARE compressed INT DEFAULT 1;
+ SELECT compressed;
+END
+$$
+DELIMITER ;$$