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

10.11-11.8 rollback on CREATE TEMPORARY TABLE ... SELECT errors

    XMLWordPrintable

Details

    • Can result in unexpected behaviour
    • An error during the execution of CREATE TEMPORARY TABLE…SELECT no longer results in a rollback of the entire transaction, but of the failing statement.

    Description

      Reusing the test case from MDEV-36787

      --source include/have_innodb.inc
      CREATE TABLE t (a INT) ENGINE=InnoDB;
      START TRANSACTION;
      SELECT * FROM t;
      SAVEPOINT A;
      --error ER_WARN_DATA_OUT_OF_RANGE
      CREATE TEMPORARY TABLE tmp (a TINYINT) ENGINE=InnoDB AS SELECT 256 AS a;
      ROLLBACK TO SAVEPOINT A;
      DROP TABLE t;
      

      this unexpectedly fails with "unknown savepoint", because the transaction was rolled back as a result of 387fe5ecc3a6.

      It should be fixed as in d228f237f276. See also eba285f2a21f.

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.