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

     1  use sequence_safe_mode_test;
     2  delete from t3 where name = 'Santa Sofía de la Piedad';
     3  alter table t2 add column age int after name, add column level int after name;
     4  alter table t2 add index age(age);
     5  alter table t2 add index level(level);
     6  insert into t2 (uid, name, age) values (40002, 'Remedios Moscote', 100), (40003, 'Amaranta', 103);
     7  insert into t3 (uid, name) values (30004, 'Aureliano José'), (30005, 'Santa Sofía de la Piedad'), (30006, '17 Aurelianos');
     8  alter table t3 add column age int after name, add column level int after name;
     9  alter table t3 add index age(age);
    10  alter table t3 add index level(level);
    11  update t3 set age = 1;