[MDEV-25618] lower_case_table_names in Linux behaves like in Windows Created: 2021-05-07  Updated: 2021-05-13

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.5.9
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Philip orleans Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Linux



 Description   

my box shows lower_case_table_names=1

show variables like 'lower_case_table%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_table_names | 1     |
+------------------------+-------+

but, the column names are store in mixed case. The manual says that when this variable is equal to 1, everything should be stored in lower-case and compared in case-insensitive manner.


Generated at Thu Feb 08 09:39:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.