1--source include/have_rocksdb.inc
2
3# Issue#212 MyRocks chooses full index scan even if range scan is more efficient
4# rocksdb_debug_optimizer_n_rows must not be set.
5
6create table t1 (id1 bigint, id2 bigint, c1 bigint, c2 bigint, c3 bigint, c4 bigint, c5 bigint, c6 bigint, c7 bigint, primary key (id1, id2), index i(c1, c2));
7--disable_query_log
8let $i=0;
9while ($i<10000)
10{
11  inc $i;
12  eval insert t1(id1, id2, c1, c2, c3, c4, c5, c6, c7)
13          values($i,    0, $i,  0,  0,  0,  0,  0,  0);
14}
15--enable_query_log
16analyze table t1;
17select count(*) from t1;
18--replace_column 9 #
19explain select c1 from t1 where c1 > 5 limit 10;
20drop table t1;
21
22--echo #
23--echo # MDEV-17414: MyROCKS order desc limit 1 fails
24--echo #
25create table t1 (date date);
26insert into t1 values ('2018-10-04'), ('2018-10-05');
27select * from t1 where date < '2018-10-09' order by date desc limit 1; # Works as expected
28alter table t1 add index date_index (date);
29select * from t1 where date < '2018-10-05' order by date desc limit 1; # Works as expected
30--echo # this should not produce an empty set:
31select * from t1 where date < '2018-10-09' order by date desc limit 1;
32drop table t1;
33
34