Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Fix Version/s: 10.0.8
    • Component/s: None
    • Labels:
      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

              People

              • Assignee:
                monty Michael Widenius
                Reporter:
                monty Michael Widenius
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: