| 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 |