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

     1  drop database if exists `all_mode`;
     2  create database `all_mode`;
     3  use `all_mode`;
     4  create table t2 (
     5      id int NOT NULL AUTO_INCREMENT,
     6      name varchar(20),
     7      ts timestamp,
     8      PRIMARY KEY (id));
     9  insert into t2 (name, ts) values ('Arya', now()), ('Bran', '2021-05-11 10:01:05'), ('Sansa', NULL);
    10  
    11  -- test block-allow-list
    12  drop database if exists `ignore_db`;
    13  create database `ignore_db`;
    14  use `ignore_db`;
    15  create table `ignore_table`(id int);
    16  
    17  use `all_mode`;
    18  CREATE TABLE t3 (
    19      id INT PRIMARY KEY,
    20      j JSON,
    21      KEY j_index ((cast(json_extract(j,_utf8mb4'$[*]') as signed array)), id)
    22  );
    23  INSERT INTO t3 VALUES (1, '[1,2,3]'), (2, '[2,3,4]'), (3, '[3,4,5]');