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

     1  use sharding_seq;
     2  insert into t1 (uid,name) values (100003,'NR');
     3  update t1 set name = 'uxoKehvqWg' where `uid` = 100001;
     4  update t1 set name = 'bapYymrtfT' where name = 'igvApUx';
     5  insert into t2 (uid,name) values (200004,'CXDvoltoliUINgo'),(200005,'188689130');
     6  alter table t1 add column c int;
     7  alter table t1 add index c(c);
     8  update t1 set c = 100;
     9  alter table t1 add column d int;
    10  alter table t1 add index d(d);
    11  alter table t1 add column e int, add index e(e);
    12  update t1 set d = 200;
    13  alter table t2 add column c int;
    14  alter table t2 add index c(c);
    15  update t2 set c = 100;
    16  alter table t2 add column d int;
    17  alter table t2 add index d(d);
    18  alter table t2 add column e int, add index e(e);
    19  update t2 set d = 200;
    20  update t1 set c = 101;
    21  update t2 set c = 102;
    22  insert into t1 (uid,name,c) values(100004,'VALUES',191472878),(100005,'jAPlnzXli',1091218279);