#
# 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;