From 997445bc8eb578355b41abc3f4e42f579f900043 Mon Sep 17 00:00:00 2001 From: Sergey Petrunya Date: Sat, 2 Apr 2011 14:04:45 +0400 Subject: Make EXPLAIN better at displaying MRR/BKA: - "Using MRR" is no longer shown with range access. - Instead, both range and BKA accesses will show one of the following: = "Rowid-ordered scan" = "Key-ordered scan" = "Key-ordered Rowid-ordered scan" depending on whether DS-MRR implementation will do scan keys in order, rowids in order, or both. - The patch also introduces a way for other storage engines/MRR implementations to pass information to EXPLAIN output about the properties of employed MRR scans. --- mysql-test/r/null.result | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'mysql-test/r/null.result') diff --git a/mysql-test/r/null.result b/mysql-test/r/null.result index 7cadeb81c2c..54729bd6937 100644 --- a/mysql-test/r/null.result +++ b/mysql-test/r/null.result @@ -148,10 +148,10 @@ insert into t1 values (7,7), (8,8), (9,9), (10,10), (11,11), (12,12); explain select * from t1 where a between 2 and 3; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range idx idx 4 NULL 2 Using index condition; Using MRR +1 SIMPLE t1 range idx idx 4 NULL 2 Using index condition; Rowid-ordered scan explain select * from t1 where a between 2 and 3 or b is null; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range idx idx 4 NULL 2 Using index condition; Using MRR +1 SIMPLE t1 range idx idx 4 NULL 2 Using index condition; Rowid-ordered scan drop table t1; select cast(NULL as signed); cast(NULL as signed) -- cgit v1.2.1