github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/engine/test/integration_tests/dm_case_sensitive/data/db2.prepare.sql (about)

     1  drop database if exists `lower_db`;
     2  create database `lower_db` collate utf8mb4_general_ci;
     3  use `lower_db`;
     4  create table Upper_Table (
     5      id int NOT NULL AUTO_INCREMENT,
     6      name varchar(20),
     7      ts timestamp,
     8      PRIMARY KEY (id));
     9  insert into Upper_Table (name, ts) values ('Arya', now()), ('Bran', '2021-05-11 10:01:05'), ('Sansa', NULL);
    10  
    11  -- if case-insensitive, this should report conflict with Upper_Table
    12  create table upper_table(id int NOT NULL PRIMARY KEY);
    13  
    14  -- test block-allow-list
    15  drop database if exists `lower_db_ignore`;
    16  create database `lower_db_ignore`;
    17  use `lower_db_ignore`;
    18  create table `Upper_Table`(id int);