Comments - Identifier Case-sensitivity
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
I am developing an application on Windows, later in production it is meant to run on Linux. So case sensitivity is an issue for me.
During development with MariaDB on Windows version 10.4.8 I perceive my application receives an exception on insert into column 'Owner_Details' when only 'Owner_details' is in the database. My application is smart enough to care about this by adding the column on the fly. However on 'alter table ... add column Owner_Details' I get a 'duplicate column name' error.
So does the column exist or not? If the windows version were consistent in not caring about the case the error upon insert should not happen in first place.