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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.