[MDEV-12584] Alter table changes frm file to UpperCase in Windows Creators Update Created: 2017-04-25  Updated: 2020-03-25  Resolved: 2020-03-25

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table
Affects Version/s: 10.1.22
Fix Version/s: N/A

Type: Bug Priority: Trivial
Reporter: Michael Dhaene Assignee: Vladislav Vaintroub
Resolution: Cannot Reproduce Votes: 0
Labels: alter, windows
Environment:

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.

 Comments   
Comment by Elena Stepanova [ 2017-05-01 ]

wlad, do you want to follow up on this one?

A very quick search suggests that Creators update has multiple issues, including something related to case-sensitivity, maybe those are a factor here, but i didn't dig into it.

Please feel free to close as not a bug if that's the conclusion you come to.

Comment by Vladislav Vaintroub [ 2020-03-25 ]

Does not seem to change the case for me, on the examples.
of course I've no original CreatorsUpdate anymore, from 2017

Generated at Thu Feb 08 07:58:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.