From 84485dbe7c994ad938cd2ee90d5dee96059192e2 Mon Sep 17 00:00:00 2001
From: Sergei Petrunia <psergey@askmonty.org>
Date: Tue, 12 Aug 2014 15:02:09 +0400
Subject: MDEV-6109: EXPLAIN JSON

Add pretty-printing of possible_keys column.
---
 mysql-test/r/explain_json.result | 31 +++++++++++++++++++++++++++++++
 mysql-test/t/explain_json.test   | 18 +++++++++---------
 2 files changed, 40 insertions(+), 9 deletions(-)

(limited to 'mysql-test')

diff --git a/mysql-test/r/explain_json.result b/mysql-test/r/explain_json.result
index de902a7c31a..6f38892ef05 100644
--- a/mysql-test/r/explain_json.result
+++ b/mysql-test/r/explain_json.result
@@ -38,4 +38,35 @@ EXPLAIN
     }
   }
 }
+create table t1 (a int, b int, filler char(32), key(a));
+insert into t1 
+select 
+A.a + B.a* 10 + C.a * 100, 
+A.a + B.a* 10 + C.a * 100,
+'filler'
+from t0 A, t0 B, t0 C;
+explain format=json select * from t0,t1 where t1.a=t0.a;
+EXPLAIN
+{
+  "query_block": {
+    "select_id": 1,
+    "table": {
+      "table_name": "t0",
+      "access_type": "ALL",
+      "rows": 10,
+      "filtered": 100,
+      "attached_condition": "(t0.a is not null)"
+    },
+    "table": {
+      "table_name": "t1",
+      "access_type": "ref",
+      "possible_keys": ["a"],
+      "key": "a",
+      "used_key_parts": "TODO",
+      "key_length": "5",
+      "rows": 1,
+      "filtered": 100
+    }
+  }
+}
 drop table t0;
diff --git a/mysql-test/t/explain_json.test b/mysql-test/t/explain_json.test
index e9306101f81..aedff8d78cb 100644
--- a/mysql-test/t/explain_json.test
+++ b/mysql-test/t/explain_json.test
@@ -14,14 +14,14 @@ explain format=json select * from t0 where 1>2;
 
 explain format=json select * from t0 where a<3;
 
-#create table t1 (a int, b int, filler char(32), key(a));
-#insert into t1 
-#select 
-#  A.a + B.a* 10 + C.a * 100, 
-#  A.a + B.a* 10 + C.a * 100,
-#  'filler'
-#from t0 A, t0 B, t0 C;
-#
-#explain format=json select * from t0,t1 where t1.a=t0.a;
+create table t1 (a int, b int, filler char(32), key(a));
+insert into t1 
+select 
+  A.a + B.a* 10 + C.a * 100, 
+  A.a + B.a* 10 + C.a * 100,
+  'filler'
+from t0 A, t0 B, t0 C;
+
+explain format=json select * from t0,t1 where t1.a=t0.a;
 
 drop table t0;
-- 
cgit v1.2.1