diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2023-01-10 13:58:03 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2023-01-10 13:58:03 +0200 |
| commit | ab36eac584a0bef4a048a3fd8ae56ff2cbfcb6cc (patch) | |
| tree | 0d1b90c00ead9bf4e429168d00c0ccb123d1e887 /mysql-test/main/range_aria_dbt3.test | |
| parent | 8356fb68c366b7f515f9060d964ee598653756a6 (diff) | |
| parent | 56c9b0bca0576985c31f20b46dcb060a01e81a2b (diff) | |
| download | mariadb-git-ab36eac584a0bef4a048a3fd8ae56ff2cbfcb6cc.tar.gz | |
Merge 10.6 into 10.7
Diffstat (limited to 'mysql-test/main/range_aria_dbt3.test')
| -rw-r--r-- | mysql-test/main/range_aria_dbt3.test | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/main/range_aria_dbt3.test b/mysql-test/main/range_aria_dbt3.test new file mode 100644 index 00000000000..89328280987 --- /dev/null +++ b/mysql-test/main/range_aria_dbt3.test @@ -0,0 +1,24 @@ +# +# This is generic tests using dbt3_s001 tables +# This file uses the Aria storage engine +# + +set default_storage_engine=Aria; + +CREATE DATABASE dbt3_s001; +use dbt3_s001; +--disable_query_log +--source include/dbt3_s001.inc +--enable_query_log + +--echo # +--echo # MDEV-30325 Wrong result upon range query using index condition +--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 ); + +--echo # +--echo # End of 10.5 tests +--echo # + +DROP DATABASE dbt3_s001; |