summaryrefslogtreecommitdiff
path: root/mysql-test/t/explain_json.test
diff options
context:
space:
mode:
authorSergei Petrunia <psergey@askmonty.org>2014-11-29 03:28:46 +0300
committerSergei Petrunia <psergey@askmonty.org>2014-11-29 03:28:46 +0300
commitc46eadb2b33ca152525a18d9b5425fedbef7f277 (patch)
tree125d506cc6d8fe91e0b163a7e9e2d3daddb1e787 /mysql-test/t/explain_json.test
parente235bb864d2b8daae3dc7061249f59fb0127bdc5 (diff)
downloadmariadb-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.test9
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 #