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

Alter table changes frm file to UpperCase in Windows Creators Update

    XMLWordPrintable

    Details

      Description

      After installing the creators update I noticed that tables didn't show up anymore after altering a table to add a column.

      I have lower_case_table_names variable set on my system to:
      lower_case_table_names = 2

      Procedure:

      CREATE TABLE IF NOT EXISTS `repository_1`.`Table_1` (ID INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT) ENGINE = INNODB

      Results in two files:
      Table_1.frm
      table_1.ibd

      Show tables command shows me Table_1.

      ALTER TABLE `repository_1`.`Table_1` ADD COLUMN `Column_1` TEXT NULL

      Results in two files:
      TABLE_1.FRM
      table_1.ibd

      Show tables command does not return Table_1. Although DESCRIBE Table_1 does:

      Field Type Null Key Default Extra
      ID int(11) NO PRI NULL auto_increment
      Column_1 text YES   NULL  

      Changing the lower_case_table_names to use value 1 works but all my tables and files are lowercase which is not what I want.

        Attachments

          Activity

            People

            Assignee:
            wlad Vladislav Vaintroub
            Reporter:
            michaeld Michael Dhaene
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: