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