View names automatically change to lower case

klaus.kirchhoff's profile image klaus.kirchhoff posted 4 years ago in General Permalink

I am facing a problem with upper / lower case view names. Originally the views are created with upper case names. After changing something in views query the view name changes to lower case. My application runs on centos and is case sensitive.

Regardles of how the corresponding Maria Variables are set to, a tool like HeidiSQL should never change something by its own.

My setting:

Variable_name;Value lower_case_file_system;ON lower_case_table_names;2

Cheers, Klaus

ansgar's profile image ansgar posted 4 years ago Permalink

Seems to be normal, according to the documentation: https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html

HeidiSQL itself does not change the case.

klaus.kirchhoff's profile image klaus.kirchhoff posted 4 years ago Permalink

Thanks, you are right! I picked the statement form Hiedis log output: ALTER ALGORITHM = UNDEFINED DEFINER=root@localhost SQL SECURITY DEFINER VIEW V_TRANSACTION_CP AS SELECT... The name is in upper case. Funny behavior of Maria. I have to dig deeper here.

Please login to leave a reply, or register at first.