github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/engine/test/integration_tests/dm_case_sensitive/data/db1.prepare.sql (about) 1 drop database if exists `Upper_DB`; 2 create database `Upper_DB`; 3 use `Upper_DB`; 4 create table Do_Table ( 5 id int NOT NULL AUTO_INCREMENT, 6 name varchar(20), 7 dt datetime, 8 ts timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 9 PRIMARY KEY (id)); 10 -- test ANSI_QUOTES works with quote in string 11 insert into Do_Table (id, name, dt, ts) values (1, 'ar"ya', now(), now()), (2, 'catelyn', '2021-05-11 10:01:05', '2021-05-11 10:01:05'); 12 13 create table Do_table_ignore(id int PRIMARY KEY); 14 insert into Do_table_ignore values (1); 15 16 create table lower_table (id int NOT NULL, val varchar(12), PRIMARY KEY (id)); 17 insert into lower_table (id, val) values (0, 'lalala'); 18 19 -- should be ignored 20 create table lower_Table1 (id int NOT NULL PRIMARY KEY); 21 22 drop database if exists `Upper_DB1`; 23 create database `Upper_DB1`; 24 use `Upper_DB1`; 25 create table Do_Table1 (id int NOT NULL AUTO_INCREMENT, name varchar(20), PRIMARY KEY (id)); 26 insert into Do_Table1 (id, name) values (1, 'test'), (2, 'test2'); 27 28 drop database IF EXISTS `Upper_Db_IGNORE`; 29 create database `Upper_Db_IGNORE`; 30 use `Upper_Db_IGNORE`; 31 create table `ignore_table`(id int);