Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5082

EXPLAIN INSERT .. VALUES works as INSERT (adds rows to the table)

    XMLWordPrintable

    Details

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              psergey Sergei Petrunia
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: