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

     1  use `sharding_seq_opt`;
     2  
     3  -- try to update the downstream schema before applying any DML
     4  alter table t4 add column c3 int;
     5  -- at this point:
     6  --      t2(id, c1, c2)
     7  --      t3(id, c1, c2)
     8  --      t4(id, c1, c2, c3)
     9  insert into t4 (id, c1, c2, c3) values (500004, '510004', '520004', 530004);
    10  insert into t2 (id, c1, c2) values (300004, '310004', '320004');
    11  insert into t3 (id, c1, c2) values (400004, '410004', '420004');
    12  
    13  alter table t4 drop column c1;
    14  -- at this point:
    15  --      t2(id, c1, c2)
    16  --      t3(id, c1, c2)
    17  --      t4(id,     c2, c3)
    18  insert into t3 (id, c1, c2) values (400005, '410005', '420005');
    19  insert into t4 (id, c2, c3) values (500005, '520005', 530005);
    20  insert into t2 (id, c1, c2) values (300005, '310005', '320005');
    21  
    22  alter table t2 drop column c1;
    23  -- at this point:
    24  --      t2(id,     c2)
    25  --      t3(id, c1, c2)
    26  --      t4(id,     c2, c3)
    27  insert into t4 (id, c2, c3) values (500006, '520006', 530006);
    28  insert into t3 (id, c1, c2) values (400006, '410006', '420006');
    29  insert into t2 (id, c2) values (300006, '320006');
    30  
    31  alter table t2 add column c3 int;
    32  -- at this point:
    33  --      t2(id,     c2, c3)
    34  --      t3(id, c1, c2)
    35  --      t4(id,     c2, c3)
    36  insert into t2 (id, c2, c3) values (300007, '320007', 330007);
    37  insert into t4 (id, c2, c3) values (500007, '520007', 530007);
    38  insert into t3 (id, c1, c2) values (400007, '410007', '420007');
    39  
    40  alter table t3 drop column c1;
    41  -- at this point:
    42  --      t2(id, c2, c3)
    43  --      t3(id, c2)
    44  --      t4(id, c2, c3)
    45  insert into t3 (id, c2) values (400008, '420008');
    46  insert into t2 (id, c2, c3) values (300008, '320008', 330008);
    47  insert into t4 (id, c2, c3) values (500008, '520008', 530008);
    48  
    49  alter table t3 add column c3 int;
    50  -- at this point:
    51  --      t2(id, c2, c3)
    52  --      t3(id, c2, c3)
    53  --      t4(id, c2, c3)
    54  insert into t4 (id, c2, c3) values (500009, '520009', 530009);
    55  insert into t3 (id, c2, c3) values (400009, '420009', 430009);
    56  insert into t2 (id, c2, c3) values (300009, '320009', 330009);