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

CREATE TABLE IF NOT EXISTS throws an error instead of warning if the table is locked

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Fixed
        • Affects Version/s: 5.5.29
        • Fix Version/s: 5.5.29
        • Component/s: None
        • Labels:
          None

          Description

          The following test case 

          create table t1 (i int);
lock table t1 read;

--connect (con1,localhost,root,,)
# Should produce warning 1050 "Table '<name>' already exists"
create table if not exists t1 (j int);
--disconnect con1

--connection default
unlock tables;
drop table t1;

          fails with an error:

          mysqltest: At line 6: query 'create table if not exists t1 (j int)' failed: 1050: Table 't1' already exists

          It's a serious change in behavior which most likely won't be welcome in a GA version.

          branch: maria/5.5
revision-id: timour@askmonty.org-20121217132358-6af27lb65kf5kwf2
date: 2012-12-17 15:23:58 +0200
build-date: 2012-12-18 00:25:33 +0400
revno: 3596

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Task - A task that needs to be done. MDEV-3941 CREATE TABLE xxx IF NOT EXISTS should not block if table exists

                • Blocker - Blocks development and/or testing work, production could not run.
                • Closed

                  Activity

                  Hide
                  Permalink
                  monty Michael Widenius added a comment -

                  Fixed

                  Show
                  monty Michael Widenius added a comment - Fixed

                    People

                    • Assignee:
                      monty Michael Widenius
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: