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

     1  use sequence_safe_mode_test;
     2  insert into t1 (uid, name) values (10003, 'Buenos Aires');
     3  alter table t1 add column age int after name, add column level int after name;
     4  alter table t1 add index age(age);
     5  alter table t1 add index level(level);
     6  insert into t1 (uid, name, age) values (10005, 'Buenos Aires', 200);
     7  insert into t2 (uid, name) values (20005, 'Aureliano José');
     8  insert into t1 (uid, name, age) values (10006, 'Buenos Aires', 200);
     9  alter table t2 add column age int after name, add column level int after name;
    10  alter table t2 add index age(age);
    11  alter table t2 add index level(level);
    12  insert into t1 (uid, name, age) values (10007, 'Buenos Aires', 300);
    13  insert into t2 (uid, name, age) values (20006, 'Colonel Aureliano Buendía', 301);
    14  insert into t1 (uid, name, age) values (10008, 'Buenos Aires', 400);
    15  insert into t2 (uid, name, age) values (20007, 'Colonel Aureliano Buendía', 401);
    16  update t1 set age = 404 where uid = 10005;