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

     1  use online_ddl;
     2  insert into gho_t1 (uid, name, info) values (10006, 'name of 10006', '{"age": 10006}');
     3  insert into gho_t2 (uid, name, info) values (20008, 'name of 20008', '{"age": 20008}');
     4  alter table gho_t1 add column address varchar(255);
     5  alter table gho_t2 add column address varchar(255);
     6  alter table gho_t1 add key address (address);
     7  alter table gho_t2 add key address (address);
     8  insert into gho_t2 (uid, name, info, address) values (20009, 'name of 20009', '{"age": 20009}', 'address of 20009');
     9  insert into gho_t1 (uid, name, info, address) values (10007, 'name of 10007', '{"age": 10007}', 'address of 10007');
    10  alter table gho_t2 drop column age;
    11  alter table gho_t1 drop column age;
    12  insert into gho_t1 (uid, name, info, address) values (10008, 'name of 10008', '{"age": 10008}', 'address of 10008');
    13  insert into gho_t2 (uid, name, info, address) values (20010, 'name of 20010', '{"age": 20010}', 'address of 20010');