[Commits] 6dc2d58: Make rocksdb.rocksdb_range pass: MariaDB doesnt support ICP over reverse index scans atm

Sergei Petrunia psergey at askmonty.org
Wed Mar 15 22:36:20 EET 2017


revision-id: 6dc2d581d478b5563250bde6db8d8226372f96f1
parent(s): c010f06380f004adbc6f7062f656ab9dfa73e15f
committer: Sergei Petrunia
branch nick: 10.2-mariarocks
timestamp: 2017-03-15 23:36:20 +0300
message:

Make rocksdb.rocksdb_range pass: MariaDB doesnt support ICP over reverse index scans atm

---
 storage/rocksdb/mysql-test/rocksdb/r/rocksdb_range.result | 5 ++++-
 storage/rocksdb/mysql-test/rocksdb/t/rocksdb_range.test   | 3 +++
 2 files changed, 7 insertions(+), 1 deletion(-)

diff --git a/storage/rocksdb/mysql-test/rocksdb/r/rocksdb_range.result b/storage/rocksdb/mysql-test/rocksdb/r/rocksdb_range.result
index 8cf38fd..918859e 100644
--- a/storage/rocksdb/mysql-test/rocksdb/r/rocksdb_range.result
+++ b/storage/rocksdb/mysql-test/rocksdb/r/rocksdb_range.result
@@ -198,10 +198,13 @@ max(pk)
 # #48: index_read_map(HA_READ_PREFIX_LAST) does not work in reverse CF
 #
 # Tests for search_flag=HA_READ_PREFIX_LAST_OR_PREV
+# Note: the next explain has "Using index condition" in fb/mysql-5.6
+#       but "Using where" in MariaDB because the latter does not 
+#       support ICP over reverse scans.
 explain
 select * from t2 where a between 99 and 2000 order by a desc;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t2	range	a	a	4	NULL	#	Using index condition
+1	SIMPLE	t2	range	a	a	4	NULL	#	Using where
 select * from t2 where a between 99 and 2000 order by a desc;
 pk	a	b
 999	99	999
diff --git a/storage/rocksdb/mysql-test/rocksdb/t/rocksdb_range.test b/storage/rocksdb/mysql-test/rocksdb/t/rocksdb_range.test
index c6f1ecc..f4b6096 100644
--- a/storage/rocksdb/mysql-test/rocksdb/t/rocksdb_range.test
+++ b/storage/rocksdb/mysql-test/rocksdb/t/rocksdb_range.test
@@ -128,6 +128,9 @@ select max(pk) from t3 where a=3 and pk < 33;
 --echo #
 
 --echo # Tests for search_flag=HA_READ_PREFIX_LAST_OR_PREV
+--echo # Note: the next explain has "Using index condition" in fb/mysql-5.6
+--echo #       but "Using where" in MariaDB because the latter does not 
+--echo #       support ICP over reverse scans.
 --replace_column 9 #
 explain
 select * from t2 where a between 99 and 2000 order by a desc;


More information about the commits mailing list