[MDEV-5082] EXPLAIN INSERT .. VALUES works as INSERT (adds rows to the table) - JIRA

Details

create table t1 (i int);
explain insert into t1 values (1),(2);
select * from t1;

MariaDB [test]> select * from t1;
+------+
| i    |
+------+
|    1 |
|    2 |
+------+
2 rows in set (0.00 sec)

bzr version-info
revision-id: psergey@askmonty.org-20130926104732-aq7wcma425u5skrw
revno: 3700
branch-nick: 10.0-base-explain-slowquerylog

It may not return an execution plan if we don't want it to, but it certainly shouldn't insert any records.

relates to

MDEV-3798 Add EXPLAIN for UPDATE/DELETE (mwl #51)

Hide

Permalink

Sergei Petrunia added a comment - 2013-10-10 16:30

Not repeatable with the latest tree.

Show

Sergei Petrunia added a comment - 2013-10-10 16:30 Not repeatable with the latest tree.