diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2021-12-07 21:30:27 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2021-12-07 21:30:27 +0100 |
| commit | de70f921ceb27144a4b3cac8ffd0f46d3d177150 (patch) | |
| tree | 62749c09d1c4579aa2a3aa5f526b50ff84c9ea9f /mysql-test/main/range.result | |
| parent | cfcfdc65dfa0ae5e59df1f1c42ee574b8bdc60a4 (diff) | |
| parent | e8a91c18ea136f54a53ae19c6f41482a1b855cff (diff) | |
| download | mariadb-git-de70f921ceb27144a4b3cac8ffd0f46d3d177150.tar.gz | |
Merge branch '10.4' into 10.5
Diffstat (limited to 'mysql-test/main/range.result')
| -rw-r--r-- | mysql-test/main/range.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/main/range.result b/mysql-test/main/range.result index d97cfb2b587..aca500bf038 100644 --- a/mysql-test/main/range.result +++ b/mysql-test/main/range.result @@ -3280,6 +3280,30 @@ pk i v a b 2 2 4 2 4 drop table t1, t2; # +# MDEV-26553: Always FALSE/NULL disjunct on top level of WHERE is removed +# +create table t1 (a int, b int, index idx(a,b)); +insert into t1 values (1,1), (1,2), (2,1), (2,2), (3,3); +create table t2 (c int); +insert into t2 values (5), (2), (3), (4); +select 1 from t1 s1 +where 1 not in (select 1 from t1 +where ((a = 1 or a = 2) and b = 1) or (b > 5 and b < 1)); +1 +select 1 from t1 s1 +where 1 not in (select 1 from t1 +where ((a = 1 or a = 2) and b = 1) or b = NULL); +1 +select c from t2 +where 2 not in (select 1 from t1 +where ((a=1 or a=2) and b = 1) or (b > 5 and b < 1)); +c +5 +2 +3 +4 +drop table t1,t2; +# # End of 10.2 tests # # |