We were using 8.36 where, when a db is installed, default value for lower_case_table_names is always set to 1. (If value is 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.).
Screenshot of value in old system
The problem is in new 8.4 installation, the default value is set as 0. means (0 = Table and database names are stored on disk using the lettercase specified in the CREATE TABLE or CREATE DATABASE statement. Name comparisons are case-sensitive. You should not set this variable to 0 if you are running MySQL on a system that has case-insensitive file names (such as Windows or macOS). If you force this variable to 0 with --lower-case-table-names=0 on a case-insensitive file system and access MyISAM tablenames using different lettercases, index corruption may result.)
Now some queries may break if this happens. Now i have to manually reinitialize the database and change value.
Screenshot in 8.4
Can you look into this ? because some of our development happens in windows and in windows its case insnsitive. So manyy places there will be missmatch. in earlier version whatever be the case, it all stores in lowercase. Wheer as with value 0, it will be case sensitive.