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