Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

View names automatically change to lower case

klaus.kirchhoff's profile image klaus.kirchhoff posted 2 weeks 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 2 weeks 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 2 weeks 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.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.