Were attempting to migrate mysql servers to MariaDB on a new AWS (amazon-linux-2) instance.
After creating a new instance and installing mariadb we've dumped the old database via
mysqldump ... --add-drop-database --triggers --routines --events
and imported into the new system using
mysql -u ... < dump.sql
The database has a table defined with mixture of uppercase and lower case columns e.g
The original database, via
mysqld -V, is
mysqld Ver 14.14 Distrib 5.5.62, for Linux (x86_64)
The new database is, via
mysqld -V, is
mysqld Ver 15.1 Distrib 5.5.64-MariaDB, for Linux (x86_64)
yum install mariadb-server
I've verified the schema's columns match for the table in question.
Querying the table with a select statement requesting the columns as lowercase. (I've connected a local application and tested executing the same query against both database)
SELECT column1,column2,column3,etc from TABLE1 where ..
The results from the query from the original database respect the casing in the "select" statement, however in the new mariadb database, the query results match the column casing as defined in the table.
Is there a setting that can be applied that will cause the result column names to respect the casing in the "SELECT" statement, and therefore cause the result column names returned by the same select statement in both databases to match?
A testcase under MariaDB and Mysql
select cname from (select s.CName from (select 'A' as CNAME) s) t;
Under MariaDB the result set column casing matches the column from the intermediary temp table.
With the same query using the source mysql database,
The result set column name's casing matches the casing in the select statement