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

"Create table like" statement ignores capitalization

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 5.5, 10.0, 10.1, 10.1.23, 10.2
    • 10.4, 10.5
    • Platform Windows, Server
    • Windows 7, 64Bit,
      lower_case_table_names=2,
      Engine=MyISAM,
      MariaDB 10.1.23

    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

              sanja Oleksandr Byelkin
              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.