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

     1  use online_ddl;
     2  delete from pt_t3 where name = 'Santa Sofía de la Piedad';
     3  alter table pt_t2 add column age int;
     4  update pt_t2 set uid = uid + 10000;
     5  alter table pt_t3 add column age int;
     6  update pt_t3 set age = 1;
     7  alter table pt_t2 add key name (name);
     8  alter table pt_t3 add key name (name);
     9  alter table pt_t2 add column info_json json GENERATED ALWAYS AS (`info`) VIRTUAL;
    10  update pt_t3 set age = age + 10;
    11  alter table pt_t3 add column info_json json GENERATED ALWAYS AS (`info`) VIRTUAL;
    12  update pt_t2 set age = age + 10;