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

     1  use sharding_seq;
     2  delete from t3 where uid = 400002;
     3  insert into t4 (uid,name) values(500005,'`.`'),(500006,'exit');
     4  alter table t2 add column c int;
     5  alter table t2 add index c(c);
     6  update t2 set c = 100;
     7  alter table t2 add column d int;
     8  alter table t2 add index d(d);
     9  alter table t2 add column e int, add index e(e);
    10  update t2 set d = 200;
    11  alter table t3 add column c int;
    12  alter table t3 add index c(c);
    13  update t3 set c = 100;
    14  alter table t3 add column d int;
    15  alter table t3 add index d(d);
    16  alter table t3 add column e int, add index e(e);
    17  update t3 set d = 200;
    18  alter table t4 add column c int;
    19  alter table t4 add index c(c);
    20  update t4 set c = 100;
    21  alter table t4 add column d int;
    22  alter table t4 add index d(d);
    23  alter table t4 add column e int, add index e(e);
    24  update t4 set d = 200;
    25  update t4 set uid=uid+100000;
    26  insert into t2 (uid,name,c) values(300003,'nvWgBf',73),(300004,'nD1000',4029);
    27  insert into t3 (uid,name,c) values(400004,'1000',1000);