Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Cannot Reproduce
-
10.1.22
-
Windows 10 64-bit Creators update
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.