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

     1  use 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;
     5  insert into t1 (uid, name, age, age2) values (10010, 'Buenos Aires', 200, 404);
     6  insert into t2 (uid, name, age) values (20009, 'Colonel Aureliano Buendía', 100);
     7  update t2 set age = age + 1 where uid = 20008;
     8  update t2 set age = age + 2 where uid = 20007;
     9  update t2 set age = age + 1 where uid = 20009;
    10  update t1 set age = age + 1 where uid = 10008;
    11  update t1 set age = age + 1 where uid = 10009;
    12  alter table t2 add column age2 int;
    13  update t1 set age = age + 1 where uid in (10010, 10011);
    14  update t2 set age = age + 1 where uid in (20009, 20010);