diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2014-11-28 02:36:31 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2014-11-28 02:36:31 +0300 |
| commit | d5fbfb9a93704ebe4b1df37f74850a7464140991 (patch) | |
| tree | bdb7b297fd87a9c55d294f7da7271fcc77245bd3 /mysql-test/t/explain_json.test | |
| parent | 461dbd80d2ea96034f330dd238282d2167ed2c4d (diff) | |
| download | mariadb-git-d5fbfb9a93704ebe4b1df37f74850a7464140991.tar.gz | |
EXPLAIN FORMAT=JSON: Add support for single-table UPDATE/DELETE.
Diffstat (limited to 'mysql-test/t/explain_json.test')
| -rw-r--r-- | mysql-test/t/explain_json.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/explain_json.test b/mysql-test/t/explain_json.test index 6dc54f1492b..6a58796ab13 100644 --- a/mysql-test/t/explain_json.test +++ b/mysql-test/t/explain_json.test @@ -70,5 +70,15 @@ select * from t1 A, t1 B where A.a=B.a and A.b < 3 and B.b < 5; drop table t1; +--echo # +--echo # Single-table UPDATE/DELETE +--echo # +explain format=json delete from t0; +explain format=json delete from t0 where 1 > 2; + +explain format=json delete from t0 where a < 3; + +explain format=json update t0 set a=3 where a in (2,3,4); + drop table t0; |