Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.8
    • None
    • None

    Description

      Implementation of CREATE OR REPLACE TABLE.

      This is needed to make replication with GTID work reliable with CREATE ... SELECT.

      Using CREATE OR REPLACE TABLE will be identical to

      DROP TABLE IF EXISTS table_name;
      CREATE TABLE ...;

      Except that:

      • The above will be atomic (now one can create the same table between drop and create).
      • Temporary tables will not shadow the table name for the DROP
      • The CREATE TABLE tells us already if we are using a temporary table or not.
      • If this would not be the case, we could with the statement drop a temporary table but still not be able to create the original table.

      Attachments

        Issue Links

          Activity

            monty Michael Widenius created issue -
            monty Michael Widenius made changes -
            Field Original Value New Value
            monty Michael Widenius made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            monty Michael Widenius made changes -
            Description Implementation of CREATE OR REPLACE TABLE.

            This is needed to make replication with GTID work reliable with CREATE ... SELECT.

            Using CREATE OR REPLACE TABLE will be identical to

            DROP TABLE IF EXISTS table_name;
            CREATE TABLE ...;

            Except that it will be atomic.
            Implementation of CREATE OR REPLACE TABLE.

            This is needed to make replication with GTID work reliable with CREATE ... SELECT.

            Using CREATE OR REPLACE TABLE will be identical to

            DROP TABLE IF EXISTS table_name;
            CREATE TABLE ...;

            Except that:
            - The above will be atomic (now one can create the same table between drop and create).
            - Temporary tables will not shadow the table name for the DROP
              - The CREATE TABLE tells us already if we are using a temporary table or not.
              - If this would not be the case, we could with the statement drop a temporary table but still not be able to create the original table.
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0.8 [ 14200 ]
            Fix Version/s 10.0.7 [ 14100 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0.9 [ 14400 ]
            Fix Version/s 10.0.8 [ 14200 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0.8 [ 14200 ]
            Fix Version/s 10.0.9 [ 14400 ]
            serg Sergei Golubchik made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 31745 ] MariaDB v2 [ 44737 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 44737 ] MariaDB v3 [ 64127 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 64127 ] MariaDB v4 [ 132244 ]

            People

              monty Michael Widenius
              monty Michael Widenius
              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.