github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/lightning_mode/data/db1.prepare.sql (about)

     1  drop database if exists `lightning_mode`;
     2  create database `lightning_mode`;
     3  use `lightning_mode`;
     4  create table t1 (
     5      id int NOT NULL AUTO_INCREMENT,
     6      name varchar(20),
     7      PRIMARY KEY (id));
     8  -- test ANSI_QUOTES works with quote in string
     9  insert into t1 (id, name) values (1, 'ar"ya'), (2, 'catelyn');
    10  
    11  -- test sql_mode=NO_AUTO_VALUE_ON_ZERO
    12  insert into t1 (id, name) values (0, 'lalala');
    13  
    14  -- test duplicate detection
    15  create table dup1 (
    16      id INT PRIMARY KEY,
    17      name VARCHAR(20)
    18  );
    19  insert into dup1 values (1, 'a'), (2, 'b'), (3, 'c');
    20  
    21  create table dup2 (
    22      id INT PRIMARY KEY,
    23      name VARCHAR(20)
    24  );
    25  insert into dup2 values (1, 'a2'), (2, 'b2'), (3, 'c2');
    26  
    27  -- test block-allow-list
    28  drop database if exists `ignore_db`;
    29  create database `ignore_db`;
    30  use `ignore_db`;
    31  create table `ignore_table`(id int);