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

     1  use `sharding_seq_opt`;
     2  
     3  -- at this point:
     4  --      t1(id, c1, c2)
     5  --      t2(id, c1, c2)
     6  insert into t2 (id, c1, c2) values (200003, '210003', '220003');
     7  insert into t1 (id, c1, c2) values (100003, '110003', '120003');
     8  
     9  alter table t1 drop column c1;
    10  -- at this point:
    11  --      t1(id,     c2)
    12  --      t2(id, c1, c2)
    13  insert into t1 (id, c2) values (100004, '120004');
    14  insert into t2 (id, c1, c2) values (200004, '210004', '220004');
    15  
    16  alter table t2 add column c3 int;
    17  -- at this point:
    18  --      t1(id,     c2)
    19  --      t2(id, c1, c2, c3)
    20  insert into t2 (id, c1, c2, c3) values (200005, '210005', '220005', 230005);
    21  insert into t1 (id, c2) values (100005, '120005');
    22  
    23  alter table t2 drop column c1;
    24  -- at this point:
    25  --      t1(id, c2)
    26  --      t2(id, c2, c3)
    27  insert into t1 (id, c2) values (100006, '120006');
    28  insert into t2 (id, c2, c3) values (200006, '220006', 230006);
    29  
    30  alter table t1 add column c3 int;
    31  -- at this point:
    32  --      t1(id, c2, c3)
    33  --      t2(id, c2, c3)
    34  insert into t2 (id, c2, c3) values (200007, '220007', 230007);
    35  insert into t1 (id, c2, c3) values (100007, '120007', 130007);