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

     1  use sharding1;
     2  delete from t3 where name = 'Santa Sofía de la Piedad';
     3  insert into t2 (uid, name, info) values (40001, 'Amaranta', '{"age": 0}'); # DML to trigger fetch schema from downstream before DDL
     4  alter table t2 add column age int;
     5  update t2 set uid = uid + 10000;
     6  alter table t3 add column age int;
     7  update t3 set age = 1;
     8  alter table t2 add column info_json json GENERATED ALWAYS AS (`info`) VIRTUAL;
     9  update t3 set age = age + 10;
    10  alter table t3 add column info_json json GENERATED ALWAYS AS (`info`) VIRTUAL;
    11  alter table t3 add column id_gen int as (uid + 1);
    12  alter table t2 add column id_gen int as (uid + 1);
    13  alter table t2 add unique (id_gen);
    14  alter table t3 add unique (id_gen);
    15  update t2 set age = age + 10;
    16  alter table t2 add key multi_col_idx(uid, id_gen);
    17  alter table t3 add key multi_col_idx(uid, id_gen);
    18  update t3 set age = age + 10;
    19  
    20  -- test ZERO_DATE
    21  alter table t2 add column create_by DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';
    22  insert into t2 (uid, name, info, create_by) values (5, 'HaHa', '{"age": 300}', now());
    23  insert into t2 (uid, name, info, create_by) values (6, 'HiHi', '{"age": 400}', '0000-00-00 00:00:01');
    24  alter table t3 add column create_by DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';
    25  insert into t3 (uid, name, info, create_by) values (7, 'HaHa', '{"age": 300}', now());
    26  insert into t3 (uid, name, info, create_by) values (8, 'HiHi', '{"age": 400}', '0000-00-00 00:00:01')