summaryrefslogtreecommitdiff
path: root/mysql-test/t
diff options
context:
space:
mode:
authorSergei Petrunia <psergey@askmonty.org>2014-12-06 02:23:37 +0300
committerSergei Petrunia <psergey@askmonty.org>2014-12-06 02:23:37 +0300
commita80a797686e72644e0ad479fdfd2a3b56c4ddf05 (patch)
tree23bc5442b16cfa432e0ae940f14ffa748aff43e5 /mysql-test/t
parent9cac7649eade35f2e5a52e4107067701de315abc (diff)
downloadmariadb-git-a80a797686e72644e0ad479fdfd2a3b56c4ddf05.tar.gz
EXPLAIN FORMAT=JSON: Support "range checked for each record"
Diffstat (limited to 'mysql-test/t')
-rw-r--r--mysql-test/t/explain_json.test5
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/explain_json.test b/mysql-test/t/explain_json.test
index 5b6a0e135eb..0ecc09691e0 100644
--- a/mysql-test/t/explain_json.test
+++ b/mysql-test/t/explain_json.test
@@ -145,6 +145,11 @@ set optimizer_switch='mrr=on,mrr_sort_keys=on';
explain format=json select * from t1 where a < 3;
+--echo # 'Range checked for each record'
+set optimizer_switch=@tmp;
+explain format=json
+select * from t1 tbl1, t1 tbl2 where tbl2.a < tbl1.b;
+
drop table t1;
drop table t0;