diff options
author | Oleksandr Byelkin <sanja@mariadb.com> | 2023-04-21 09:10:58 +0200 |
---|---|---|
committer | Oleksandr Byelkin <sanja@mariadb.com> | 2023-04-21 09:10:58 +0200 |
commit | 3d27f6d7f46121ba0b945818e59ec221c77ad378 (patch) | |
tree | e48f88ba77d3826eb76ca08ca7c836cec7b975ab /mysql-test/main/parser.test | |
parent | fc6e8a3d3264078bed28632a289130b1dc24daea (diff) | |
parent | 4c4939bbf619d7e516131c0b3e5691b1c2d2ff8f (diff) | |
download | mariadb-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.test | 17 |
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 |