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

"Create table like" statement ignores capitalization

    XMLWordPrintable

    Details

      Description

      I am running a MariaDB server on Windows with lower_case_table_names=2 (i.e. names are stored as declared, but compared in lowercase).

      If I create a new table using the "CREATE TABLE LIKE" statement, the capitalization
      of the target table name is ignored and the lower case spelling is used instead.
      The following two SQL statements reproduce the issue:

      CREATE TABLE `TestTable` (`TestColumn` INT NULL, INDEX `TestIndex` (`TestColumn`)) ENGINE=MyISAM;
      CREATE TABLE `AnotherTable` LIKE `TestTable`;

      After execution, the second table is called "anothertable" in the database, not "AnotherTable" as expected.

      Might be related to MDEV-12800

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              mniemeier Martin Niemeier
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.