diff options
author | Sergei Petrunia <psergey@askmonty.org> | 2014-11-29 03:28:46 +0300 |
---|---|---|
committer | Sergei Petrunia <psergey@askmonty.org> | 2014-11-29 03:28:46 +0300 |
commit | c46eadb2b33ca152525a18d9b5425fedbef7f277 (patch) | |
tree | 125d506cc6d8fe91e0b163a7e9e2d3daddb1e787 /mysql-test/t/explain_json.test | |
parent | e235bb864d2b8daae3dc7061249f59fb0127bdc5 (diff) | |
download | mariadb-git-c46eadb2b33ca152525a18d9b5425fedbef7f277.tar.gz |
EXPLAIN FORMAT=JSON: support EXPLAIN FORMAT=JSON INSERT ...
Diffstat (limited to 'mysql-test/t/explain_json.test')
-rw-r--r-- | mysql-test/t/explain_json.test | 9 |
1 files changed, 8 insertions, 1 deletions
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 # |