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

            Activity

              People

              Assignee:
              monty Michael Widenius
              Reporter:
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration