summaryrefslogtreecommitdiff
path: root/mysql-test/main/parser.test
diff options
context:
space:
mode:
authorOleksandr Byelkin <sanja@mariadb.com>2023-04-21 09:10:58 +0200
committerOleksandr Byelkin <sanja@mariadb.com>2023-04-21 09:10:58 +0200
commit3d27f6d7f46121ba0b945818e59ec221c77ad378 (patch)
treee48f88ba77d3826eb76ca08ca7c836cec7b975ab /mysql-test/main/parser.test
parentfc6e8a3d3264078bed28632a289130b1dc24daea (diff)
parent4c4939bbf619d7e516131c0b3e5691b1c2d2ff8f (diff)
downloadmariadb-git-3d27f6d7f46121ba0b945818e59ec221c77ad378.tar.gz
Merge branch '10.3' into 10.4
Diffstat (limited to 'mysql-test/main/parser.test')
-rw-r--r--mysql-test/main/parser.test17
1 files changed, 15 insertions, 2 deletions
diff --git a/mysql-test/main/parser.test b/mysql-test/main/parser.test
index 13126b77f78..ee0b8e819b4 100644
--- a/mysql-test/main/parser.test
+++ b/mysql-test/main/parser.test
@@ -1681,8 +1681,21 @@ SET @@sql_mode=@save_sql_mode;
--echo #
--echo # MDEV-30151 parse error 1=2 not between/in
--echo #
-select 1=2 not in (3,4);
-select 1=2 not between 3 and 4;
+
+SELECT 1=2 NOT IN (3,4);
+SELECT 1=2 NOT BETWEEN 3 AND 4;
+
+CREATE TABLE t1 ( f INT AS ( 1 IN ( 2 NOT BETWEEN 3 AND 4 ) ) );
+SHOW CREATE TABLE t1;
+DROP TABLE t1;
+
+CREATE TABLE t1 ( f INT, CHECK ( 1 IN ( 2 NOT BETWEEN 3 AND 4 ) ) );
+SHOW CREATE TABLE t1;
+DROP TABLE t1;
+
+CREATE VIEW v1 AS SELECT 1 IN ( 2 NOT BETWEEN 3 AND 4 );
+SHOW CREATE VIEW v1;
+DROP VIEW v1;
--echo #
--echo # End of 10.3 tests