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

     1  drop database if exists `extend_column1`;
     2  create database `extend_column1`;
     3  use `extend_column1`;
     4  create table t1 (c1 int, c2 int, c3 int, primary key(c1));
     5  insert into t1 values(1, 1, 1);
     6  insert into t1 values(2, 2, 2);
     7  create table y1 (c1 int, c2 int, c3 int, gc3 int GENERATED ALWAYS AS (c1 + 1) VIRTUAL, primary key(c1));
     8  insert into y1 (c1, c2, c3) values(1, 1, 1);
     9  insert into y1 (c1, c2, c3) values(2, 2, 2);
    10  create table y2 (c1 int, c2 int, c3 int, gc3 int GENERATED ALWAYS AS (c1 + 1) VIRTUAL, primary key(c1));
    11  insert into y2 (c1, c2, c3) values(1, 1, 1);
    12  insert into y2 (c1, c2, c3) values(2, 2, 2);