github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/tests/integration_tests/open_protocol_handle_key_only/data/data.sql (about)

     1  drop database if exists test;
     2  create database test;
     3  use test;
     4  
     5  create table t (
     6      id          int primary key auto_increment,
     7  
     8      c_tinyint   tinyint   null,
     9      c_smallint  smallint  null,
    10      c_mediumint mediumint null,
    11      c_int       int       null,
    12      c_bigint    bigint    null,
    13  
    14      c_unsigned_tinyint   tinyint   unsigned null,
    15      c_unsigned_smallint  smallint  unsigned null,
    16      c_unsigned_mediumint mediumint unsigned null,
    17      c_unsigned_int       int       unsigned null,
    18      c_unsigned_bigint    bigint    unsigned null,
    19  
    20      c_float   float   null,
    21      c_double  double  null,
    22      c_decimal decimal null,
    23      c_decimal_2 decimal(10, 4) null,
    24  
    25      c_unsigned_float     float unsigned   null,
    26      c_unsigned_double    double unsigned  null,
    27      c_unsigned_decimal   decimal unsigned null,
    28      c_unsigned_decimal_2 decimal(10, 4) unsigned null,
    29  
    30      c_date      date      null,
    31      c_datetime  datetime  null,
    32      c_timestamp timestamp null,
    33      c_time      time      null,
    34      c_year      year      null,
    35  
    36      c_tinytext   tinytext      null,
    37      c_text       text          null,
    38      c_mediumtext mediumtext    null,
    39      c_longtext   longtext      null,
    40  
    41      c_tinyblob   tinyblob      null,
    42      c_blob       blob          null,
    43      c_mediumblob mediumblob    null,
    44      c_longblob   longblob      null,
    45  
    46      c_char       char(16)      null,
    47      c_varchar    varchar(16)   null,
    48      c_binary     binary(16)    null,
    49      c_varbinary  varbinary(16) null,
    50  
    51      c_enum enum ('a','b','c') null,
    52      c_set  set ('a','b','c')  null,
    53      c_bit  bit(64)            null,
    54      c_json json               null
    55  );
    56  
    57  insert into t values (
    58      1,
    59      1, 2, 3, 4, 5,
    60      1, 2, 3, 4, 5,
    61      2020.0202, 2020.0303, 2020.0404, 2021.1208,
    62      3.1415, 2.7182, 8000, 179394.233,
    63      '2020-02-20', '2020-02-20 02:20:20', '2020-02-20 02:20:20', '02:20:20', '2020',
    64      '89504E470D0A1A0A', '89504E470D0A1A0A', '89504E470D0A1A0A', '89504E470D0A1A0A',
    65      x'89504E470D0A1A0A', x'89504E470D0A1A0A', x'89504E470D0A1A0A', x'89504E470D0A1A0A',
    66      '89504E470D0A1A0A', '89504E470D0A1A0A', x'89504E470D0A1A0A', x'89504E470D0A1A0A',
    67      'b', 'b,c', b'1000001', '{
    68          "key1": "value1",
    69          "key2": "value2",
    70          "key3": "123"
    71      }'
    72  );
    73  
    74  update t set c_float = 3.1415, c_double = 2.7182, c_decimal = 8000, c_decimal_2 = 179394.233 where id = 1;
    75  
    76  delete from t where id = 1;
    77  
    78  insert into t values (
    79       2,
    80       1, 2, 3, 4, 5,
    81       1, 2, 3, 4, 5,
    82       2020.0202, 2020.0303, 2020.0404, 2021.1208,
    83       3.1415, 2.7182, 8000, 179394.233,
    84       '2020-02-20', '2020-02-20 02:20:20', '2020-02-20 02:20:20', '02:20:20', '2020',
    85       '89504E470D0A1A0A', '89504E470D0A1A0A', '89504E470D0A1A0A', '89504E470D0A1A0A',
    86       x'89504E470D0A1A0A', x'89504E470D0A1A0A', x'89504E470D0A1A0A', x'89504E470D0A1A0A',
    87       '89504E470D0A1A0A', '89504E470D0A1A0A', x'89504E470D0A1A0A', x'89504E470D0A1A0A',
    88       'b', 'b,c', b'1000001', '{
    89          "key1": "value1",
    90          "key2": "value2",
    91          "key3": "123"
    92      }'
    93  );
    94  
    95  update t set c_float = 3.1415, c_double = 2.7182, c_decimal = 8000, c_decimal_2 = 179394.233 where id = 2;
    96  
    97  create table finish_mark
    98  (
    99      id int PRIMARY KEY
   100  );