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

     1  use `sharding_seq_opt`;
     2  
     3  alter table t2 add column c1 varchar(20);
     4  -- at this point:
     5  --      t1(id,     c2, c3)
     6  --      t2(id, c1, c2, c3)
     7  insert into t2 (id, c1, c2, c3) values (200008, '210008', '220008', 230008);
     8  insert into t1 (id, c2, c3) values (100008, '120008', 130008);
     9  
    10  alter table t2 drop column c1;
    11  -- at this point:
    12  --      t1(id, c2, c3)
    13  --      t2(id, c2, c3)
    14  insert into t1 (id, c2, c3) values (100009, '120009', 130009);
    15  insert into t2 (id, c2, c3) values (200009, '220009', 230009);
    16