Debian Codegraph @

mysql-test/suite/innodb/r/dropdb_cs.result

raw
1 #
2 # MDEV-28802 DROP DATABASE in InnoDB still is case-insensitive
3 #
4 SET @save_fpt=@@GLOBAL.innodb_file_per_table;
5 SET GLOBAL innodb_file_per_table=0;
6 Warnings:
7 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
8 CREATE DATABASE Db;
9 CREATE TABLE Db.t1 (c1 INT KEY) ENGINE=InnoDB;
10 CREATE DATABASE DB;
11 DROP DATABASE DB;
12 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'D%';
13 NAME
14 Db/t1
15 DROP DATABASE Db;
16 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'D%';
17 TABLE_ID NAME FLAG N_COLS SPACE ROW_FORMAT ZIP_PAGE_SIZE SPACE_TYPE
18 SET GLOBAL innodb_file_per_table=@save_fpt;
19 Warnings:
20 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release