EXPLAIN FORMAT=JSON: Support "range checked for each record"

1 files changed, 26 insertions, 0 deletions

diff --git a/mysql-test/r/explain_json.result b/mysql-test/r/explain_json.result
index 42c273e7209..c9b65282047 100644
--- a/mysql-test/r/explain_json.result
+++ b/mysql-test/r/explain_json.result
@@ -691,5 +691,31 @@ EXPLAIN
     }
   }
 }
+# 'Range checked for each record'
+set optimizer_switch=@tmp;
+explain format=json
+select * from t1 tbl1, t1 tbl2 where tbl2.a < tbl1.b;
+EXPLAIN
+{
+  "query_block": {
+    "select_id": 1,
+    "table": {
+      "table_name": "tbl1",
+      "access_type": "ALL",
+      "rows": 100,
+      "filtered": 100
+    },
+    "range-checked-for-each-record": {
+      "keys": ["a"],
+      "table": {
+        "table_name": "tbl2",
+        "access_type": "ALL",
+        "possible_keys": ["a"],
+        "rows": 100,
+        "filtered": 100
+      }
+    }
+  }
+}
 drop table t1;
 drop table t0;