diff options
| author | Monty <monty@mariadb.org> | 2023-01-11 18:12:40 +0200 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2023-01-11 18:12:40 +0200 |
| commit | 7d1df207c4ded0ac8aa61f0d35bcae7eda974c54 (patch) | |
| tree | ffe460a400c5a89485a99305b3c2c9b2dea938c4 /mysql-test/main/range_aria_dbt3.test | |
| parent | 17858e03a7bfe7f154a7f8097d2473dbd1cb20f2 (diff) | |
| download | mariadb-git-7d1df207c4ded0ac8aa61f0d35bcae7eda974c54.tar.gz | |
MDEV-30373 Wrong result with range access
This issue was caused by the bug fix for
MDEV-30325 Wrong result upon range query using index condition
The bug could happen in the case of several overlapping key ranges
with OR
Diffstat (limited to 'mysql-test/main/range_aria_dbt3.test')
| -rw-r--r-- | mysql-test/main/range_aria_dbt3.test | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/mysql-test/main/range_aria_dbt3.test b/mysql-test/main/range_aria_dbt3.test index 89328280987..141bf43885b 100644 --- a/mysql-test/main/range_aria_dbt3.test +++ b/mysql-test/main/range_aria_dbt3.test @@ -16,9 +16,18 @@ use dbt3_s001; --echo # SELECT COUNT(*) FROM lineitem force index (i_l_orderkey_quantity,i_l_shipdate) WHERE l_shipdate < '1994-01-01' AND l_orderkey < 800 OR l_quantity > 3 AND l_orderkey NOT IN ( 157, 1444 ); +SELECT COUNT(*) FROM lineitem ignore index (i_l_orderkey_quantity,i_l_shipdate) WHERE l_shipdate < '1994-01-01' AND l_orderkey < 800 OR l_quantity > 3 AND l_orderkey NOT IN ( 157, 1444 ); --echo # ---echo # End of 10.5 tests +--echo # MDEV-30373 Wrong result with range access --echo # +explain SELECT COUNT(*) FROM lineitem WHERE l_orderkey BETWEEN 111 AND 262 OR ( l_orderkey BETWEEN 152 AND 672 AND l_linenumber BETWEEN 4 AND 9 ); + +SELECT COUNT(*) FROM lineitem WHERE l_orderkey BETWEEN 111 AND 262 OR ( l_orderkey BETWEEN 152 AND 672 AND l_linenumber BETWEEN 4 AND 9 ); + DROP DATABASE dbt3_s001; + +--echo # +--echo # End of 10.5 tests +--echo # |