blob: ae5a2e1329fd86b6f5076fae5a1b03eb0ce4cdb3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
set default_storage_engine=Aria;
CREATE DATABASE dbt3_s001;
use dbt3_s001;
#
# MDEV-30325 Wrong result upon range query using index condition
#
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 );
COUNT(*)
5056
#
# End of 10.5 tests
#
DROP DATABASE dbt3_s001;
|
