[MXS-1600] maxscale it seen to not coop well with lower-case-table-names=1 on cnf Created: 2018-01-10  Updated: 2018-01-16  Resolved: 2018-01-16

Status: Closed
Project: MariaDB MaxScale
Component/s: Authenticator
Affects Version/s: 2.1.11
Fix Version/s: 2.1.14

Type: Bug Priority: Major
Reporter: Massimo Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None
Environment:

galera cluster + 2 maxscale HA keepalive


Sprint: MXS-SPRINT-50

 Description   

When Mariadb configuration file has the option lower-case-table-names=1 , it seen maxscale do not consider from connection string that the case sensitive can be ignored.

Result is not detecting the presence of a schema if the case sensitive is not respect.

lower_case_table_names =1 : Table names are stored in lowercase on disk and name comparisons are not case-sensitive. MySQL converts all table names to lowercase on storage and lookup. This behavior also applies to database names and table aliases.



 Comments   
Comment by markus makela [ 2018-01-16 ]

Added the lower_case_table_names option for the MySQLAuth authenticator.

Generated at Thu Feb 08 04:08:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.