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

Implement CREATE TABLE...SELECT in one transaction

    XMLWordPrintable

Details

    Description

      As hinted in MDEV-21602, CREATE TABLE...SELECT is currently implemented in multiple transactions:

      1. Transaction(s) to create (each partition or subpartition of) the table
      2. Another transaction to execute INSERT...SELECT
      3. If an error occurs: transaction(s) to execute handler::delete_table()

      A cleaner solution would be to use a single transaction for the entire operation. If an error occurs, we would simply roll back the operation.

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-4259 transactional DDL

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-11655 Transactional data dictionary

          • Major - Major loss of function.
          • Open
          includes

          New Feature - A new feature of the product, which has yet to be developed. MDEV-25292 Atomic CREATE OR REPLACE TABLE

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25919 InnoDB reports misleading lock wait timeout on DDL operations

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21602 CREATE TABLE…PRIMARY KEY…SELECT workaround causes DROP TABLE to ignore locks

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              monty Michael Widenius
              marko Marko Mäkelä
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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