From c46eadb2b33ca152525a18d9b5425fedbef7f277 Mon Sep 17 00:00:00 2001 From: Sergei Petrunia Date: Sat, 29 Nov 2014 03:28:46 +0300 Subject: EXPLAIN FORMAT=JSON: support EXPLAIN FORMAT=JSON INSERT ... --- mysql-test/t/explain_json.test | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'mysql-test/t/explain_json.test') 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 # -- cgit v1.2.1