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

     1  use Upper_DB;
     2  insert into Do_Table (id, name, dt, ts) values (100, 'Eddard Stark', now(), '2021-05-11 12:01:05');
     3  alter table Do_Table drop column `dt`;
     4  insert into Do_Table (id, name, ts) values (101, 'Spike', '2021-05-31 12:01:05');
     5  alter table Do_Table add index `idx_name_ts` (`name`, `ts`);
     6  insert into Do_Table (id, name, ts) values (102, 'Jet', '2021-05-31 13:01:00');
     7  
     8  use Upper_DB1;
     9  insert into Do_Table1 (id, name) values (3, 'third');
    10  alter table Do_Table1 add column info json;
    11  alter table Do_Table1 add column gen_id int as (info->'$.id');
    12  alter table Do_Table1 add index multi_col(`name`, `gen_id`);
    13  insert into Do_Table1 (id, name, info) values (4, 'gentest', '{"id": 123}');
    14  insert into Do_Table1 (id, name, info) values (5, 'gentest', '{"id": 124}');
    15  update Do_Table1 set info = '{"id": 120}' where id = 1;
    16  update Do_Table1 set info = '{"id": 121}' where id = 2;
    17  update Do_Table1 set info = '{"id": 122}' where id = 3;
    18  
    19  use `Upper_Db_IGNORE`;
    20  insert into ignore_table (id) values (0);
    21  alter table ignore_table add column description varchar(32);
    22  insert into ignore_table (id, description) values (0, 'ignored');