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

     1  use online_ddl;
     2  insert into pt_t3 (uid, name, info) values (30004, 'name of 30004', '{"age": 30004}');
     3  insert into pt_t2 (uid, name, info) values (50002, 'name of 50002', '{"age": 50002}');
     4  alter table pt_t3 add column address varchar(255);
     5  alter table pt_t2 add column address varchar(255);
     6  alter table pt_t2 add key address (address);
     7  alter table pt_t3 add key address (address);
     8  insert into pt_t2 (uid, name, info, address) values (50003, 'name of 50003', '{"age": 50003}', 'address of 50003');
     9  insert into pt_t3 (uid, name, info, address) values (30005, 'name of 30005', '{"age": 30005}', 'address of 30005');
    10  alter table pt_t2 drop column age;
    11  alter table pt_t3 drop column age;
    12  insert into pt_t3 (uid, name, info, address) values (30006, 'name of 30006', '{"age": 30006}', 'address of 30006');
    13  insert into pt_t2 (uid, name, info, address) values (50004, 'name of 50004', '{"age": 50004}', 'address of 50004');