diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2013-08-26 14:43:52 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2013-08-26 14:43:52 +0400 |
| commit | eeb671325723706bbd423e00982919333a9f54cc (patch) | |
| tree | 3a488a7a3072654577fcc21b6cedbde14f41dd06 /mysql-test/t/explain_non_select.test | |
| parent | d2d9eb65e46f9afe10cd09d1b69f3d238e364c19 (diff) | |
| download | mariadb-git-eeb671325723706bbd423e00982919333a9f54cc.tar.gz | |
[SHOW] EXPLAIN UPDATE/DELETE
- Post-merge fixes (conflict with DELETE .. RETURNING)
- Add a testcase with EXPLAIN ... DELETE ... RETURNING
Diffstat (limited to 'mysql-test/t/explain_non_select.test')
| -rw-r--r-- | mysql-test/t/explain_non_select.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/explain_non_select.test b/mysql-test/t/explain_non_select.test index 523e041f620..7385ef5d420 100644 --- a/mysql-test/t/explain_non_select.test +++ b/mysql-test/t/explain_non_select.test @@ -84,3 +84,14 @@ explain update t0, t1 set t1.a=t1.a+1 where t0.a = t1.a; drop table t0, t1; + +--echo # +--echo # Try DELETE ... RETURNING ... +--echo # +create table t0 (a int); +insert into t0 values (1),(2),(3),(4); +explain delete from t0 where a=1 returning a; +explain delete from t0 returning a; +drop table t0; + + |