mirror of
https://github.com/MariaDB/server.git
synced 2025-02-05 13:22:17 +01:00
1f3f457193
innodb_drop_database(): Use explicit TO_BINARY casts on SYS_TABLES.NAME, which for historical reasons uses the wrong collation latin1_swedish_ci instead of BINARY.
17 lines
574 B
Text
17 lines
574 B
Text
--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;
|