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

     1  use sharding1;
     2  insert into t1 (uid, name) values (10003, 'Buenos Aires');
     3  update t1 set name = 'Gabriel José de la Concordia García Márquez' where `uid` = 10001;
     4  update t1 set name = 'One Hundred Years of Solitude' where name = 'Cien años de soledad';
     5  insert into t2 (uid, name, info) values (20013, 'Colonel', '{}'); # DML to trigger fetch schema from downstream before DDL
     6  alter table t1 add column age int;
     7  insert into t2 (uid, name, info) values (20023, 'Aureliano', '{}');
     8  insert into t2 (uid, name, info) values (20033, 'Buendía', '{}');
     9  alter table t2 add column age int;
    10  insert into t2 (uid, name, age, info) values (20004, 'Colonel Aureliano Buendía', 301, '{}');
    11  alter table t2 add column info_json json GENERATED ALWAYS AS (`info`) VIRTUAL;
    12  insert into t1 (uid, name, info) values (10004, 'Buenos Aires', '{"age": 10}');
    13  insert into t2 (uid, name, info) values (20005, 'Buenos Aires', '{"age": 100}');
    14  insert into t2 (uid, name, info) values (20006, 'Buenos Aires', '{"age": 1000}');
    15  alter table t1 add column info_json json GENERATED ALWAYS AS (`info`) VIRTUAL;
    16  alter table t1 add column id_gen int as (uid + 1);
    17  alter table t2 add column id_gen int as (uid + 1);
    18  alter table t1 add unique (id_gen);
    19  alter table t2 add unique (id_gen);
    20  insert into t1 (uid, name, info) values (10005, 'Buenos Aires', '{"age": 100}');
    21  insert into t2 (uid, name, info) values (20007, 'Buenos Aires', '{"age": 200}');
    22  alter table t1 add key multi_col_idx(uid, id_gen);
    23  alter table t2 add key multi_col_idx(uid, id_gen);
    24  insert into t1 (uid, name, info) values (10006, 'Buenos Aires', '{"age": 100}');
    25  insert into t2 (uid, name, info) values (20008, 'Buenos Aires', '{"age": 200}');
    26  
    27  -- test ZERO_DATE
    28  alter table t2 add column create_by DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';
    29  insert into t2 (uid, name, info, create_by) values (1, 'HaHa', '{"age": 300}', now());
    30  insert into t2 (uid, name, info, create_by) values (2, 'HiHi', '{"age": 400}', '0000-00-00 00:00:01');
    31  alter table t1 add column create_by DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';
    32  insert into t1 (uid, name, info, create_by) values (3, 'HaHa', '{"age": 300}', now());
    33  insert into t1 (uid, name, info, create_by) values (4, 'HiHi', '{"age": 400}', '0000-00-00 00:00:01');