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

     1  use online_ddl;
     2  insert into gho_t1 (uid, name) values (10003, 'Buenos Aires');
     3  update gho_t1 set name = 'Gabriel José de la Concordia García Márquez' where `uid` = 10001;
     4  update gho_t1 set name = 'One Hundred Years of Solitude' where name = 'Cien años de soledad';
     5  alter table gho_t1 add column age int;
     6  alter table gho_t2 add column age int;
     7  alter table gho_t2 add key name (name);
     8  alter table gho_t1 add key name (name);
     9  insert into gho_t2 (uid, name, age, info) values (20004, 'Colonel Aureliano Buendía', 301, '{}');
    10  alter table gho_t2 add column info_json json GENERATED ALWAYS AS (`info`) VIRTUAL;
    11  insert into gho_t1 (uid, name, info) values (10004, 'Buenos Aires', '{"age": 10}');
    12  insert into gho_t2 (uid, name, info) values (20005, 'Buenos Aires', '{"age": 100}');
    13  insert into gho_t2 (uid, name, info) values (20006, 'Buenos Aires', '{"age": 1000}');
    14  alter table gho_t1 add column info_json json GENERATED ALWAYS AS (`info`) VIRTUAL;
    15  insert into gho_t1 (uid, name, info) values (10005, 'Buenos Aires', '{"age": 100}');
    16  insert into gho_t2 (uid, name, info) values (20007, 'Buenos Aires', '{"age": 200}');