--source include/have_innodb.inc --source include/have_case_sensitive_file_system.inc --echo # --echo # MDEV-28802 DROP DATABASE in InnoDB still is case-insensitive --echo # SET @save_fpt=@@GLOBAL.innodb_file_per_table; SET GLOBAL innodb_file_per_table=0; CREATE DATABASE Db; CREATE TABLE Db.t1 (c1 INT KEY) ENGINE=InnoDB; CREATE DATABASE DB; DROP DATABASE DB; SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'D%'; DROP DATABASE Db; SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'D%'; SET GLOBAL innodb_file_per_table=@save_fpt;