Debian Codegraph @

mysql-test/suite/innodb/t/dropdb_cs.test

raw
1 --source include/have_innodb.inc
2 --source include/have_case_sensitive_file_system.inc
3 --source include/have_lowercase0.inc
4
5 --echo #
6 --echo # MDEV-28802 DROP DATABASE in InnoDB still is case-insensitive
7 --echo #
8
9 SET @save_fpt=@@GLOBAL.innodb_file_per_table;
10 SET GLOBAL innodb_file_per_table=0;
11 CREATE DATABASE Db;
12 CREATE TABLE Db.t1 (c1 INT KEY) ENGINE=InnoDB;
13 CREATE DATABASE DB;
14 DROP DATABASE DB;
15 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'D%';
16 DROP DATABASE Db;
17 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'D%';
18 SET GLOBAL innodb_file_per_table=@save_fpt;