EXPLAIN FORMAT=JSON: support EXPLAIN FORMAT=JSON INSERT ...

2 files changed, 44 insertions, 2 deletions

diff --git a/mysql-test/r/explain_json.result b/mysql-test/r/explain_json.result
index 2211c0a3ab7..8353a6b5f42 100644
--- a/mysql-test/r/explain_json.result
+++ b/mysql-test/r/explain_json.result
@@ -343,7 +343,7 @@ EXPLAIN
 }
 drop table t1;
 #
-# Single-table UPDATE/DELETE
+# Single-table UPDATE/DELETE, INSERT
 #
 explain format=json delete from t0;
 EXPLAIN
@@ -393,6 +393,41 @@ EXPLAIN
     }
   }
 }
+explain format=json insert into t0 values (1);
+EXPLAIN
+{
+  "query_block": {
+    "select_id": 1,
+    "table": {
+      "table_name": "t0"
+    }
+  }
+}
+create table t1 like t0;
+explain format=json insert into t1 values ((select max(a) from t0));
+EXPLAIN
+{
+  "query_block": {
+    "select_id": 1,
+    "table": {
+      "table_name": "t1"
+    },
+    "subqueries": [
+      {
+        "query_block": {
+          "select_id": 2,
+          "table": {
+            "table_name": "t0",
+            "access_type": "ALL",
+            "rows": 10,
+            "filtered": 100
+          }
+        }
+      }
+    ]
+  }
+}
+drop table t1;
 #
 # A derived table
 #
diff --git a/mysql-test/t/explain_json.test b/mysql-test/t/explain_json.test
index 6e3e8746e70..ed0cfdaf1eb 100644
--- a/mysql-test/t/explain_json.test
+++ b/mysql-test/t/explain_json.test
@@ -71,7 +71,7 @@ select * from t1 tbl1, t1 tbl2 where tbl1.a=tbl2.a and tbl1.b < 3 and tbl2.b < 5
 drop table t1;
 
 --echo #
---echo # Single-table UPDATE/DELETE
+--echo # Single-table UPDATE/DELETE, INSERT
 --echo #
 explain format=json delete from t0;
 explain format=json delete from t0 where 1 > 2;
@@ -80,6 +80,13 @@ explain format=json delete from t0 where a < 3;
 
 explain format=json update t0 set a=3 where a in (2,3,4);
 
+explain format=json insert into t0 values (1);
+
+create table t1 like t0;
+explain format=json insert into t1 values ((select max(a) from t0));
+
+drop table t1;
+
 --echo #
 --echo # A derived table
 --echo #