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

     1  use sequence_safe_mode_test;
     2  insert into t1 (uid, name, age) values (10009, 'Buenos Aires', 100);
     3  insert into t2 (uid, name, age) values (20008, 'Colonel Aureliano Buendía', 402);
     4  alter table t1 add column age2 int after age;
     5  alter table t1 add index age2(age2);
     6  insert into t1 (uid, name, age, age2) values (10010, 'Buenos Aires', 200, 404);
     7  insert into t2 (uid, name, age) values (20009, 'Colonel Aureliano Buendía', 100);
     8  update t2 set age = age + 1 where uid = 20008;
     9  update t2 set age = age + 2 where uid = 20007;
    10  update t2 set age = age + 1 where uid = 20009;
    11  update t1 set age = age + 1 where uid = 10008;
    12  update t1 set age = age + 1 where uid = 10009;
    13  alter table t2 add column age2 int after age;
    14  alter table t2 add index age2(age2);
    15  update t1 set age = age + 1 where uid in (10010, 10011);
    16  update t2 set age = age + 1 where uid in (20009, 20010);