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

CREATE TABLE xxx IF NOT EXISTS should not block if table exists

    Details

    • Type: Task
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Fix Version/s: 5.5.29
    • Component/s: None
    • Labels:
      None

      Description

      CREATE TABLE xxx IF NOT EXISTS should not block if table exists.

      If we notice that the table is locked (ie table exists) we will at once give an error instead of waiting for the table to be freed.

        Gliffy Diagrams

          Issue Links

            Activity

            Hide
            monty Michael Widenius added a comment -

            Pushed into 5.5 tree

            Note that this also makes CREATE TABLE to not wait if table exists.

            Show
            monty Michael Widenius added a comment - Pushed into 5.5 tree Note that this also makes CREATE TABLE to not wait if table exists.

              People

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

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4 hours Original Estimate - 4 hours
                  4h
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 5 hours
                  5h