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

     1  use `row_format`;
     2  
     3  insert into tp_int()
     4  values ();
     5  
     6  insert into tp_int(c_tinyint, c_smallint, c_mediumint, c_int, c_bigint)
     7  values (1, 2, 3, 4, 5);
     8  
     9  -- insert max value
    10  insert into tp_int(c_tinyint, c_smallint, c_mediumint, c_int, c_bigint)
    11  values (127, 32767, 8388607, 2147483647, 9223372036854775807);
    12  
    13  -- insert min value
    14  insert into tp_int(c_tinyint, c_smallint, c_mediumint, c_int, c_bigint)
    15  values (-128, -32768, -8388608, -2147483648, -9223372036854775808);
    16  
    17  insert into tp_text()
    18  values ();
    19  
    20  insert into tp_text(c_tinytext, c_text, c_mediumtext, c_longtext)
    21  values ('89504E470D0A1A0A', '89504E470D0A1A0A', '89504E470D0A1A0A',
    22          '89504E470D0A1A0A');
    23  
    24  insert into tp_char_binary(c_char, c_varchar, c_binary, c_varbinary)
    25  values('89504E470D0A1A0A', '89504E470D0A1A0A', x'89504E470D0A1A0A',
    26         x'89504E470D0A1A0A');
    27  
    28  insert into tp_blob(c_tinyblob, c_blob, c_mediumblob, c_longblob)
    29  values (x'89504E470D0A1A0A', x'89504E470D0A1A0A', x'89504E470D0A1A0A',
    30          x'89504E470D0A1A0A');
    31  
    32  insert into tp_text2() values();
    33  
    34  insert into tp_time()
    35  values ();
    36  
    37  insert into tp_time(c_date, c_datetime, c_timestamp, c_time, c_year)
    38  values ('2020-02-20', '2020-02-20 02:20:20', '2020-02-20 02:20:20', '02:20:20', '2020');
    39  
    40  insert into tp_real()
    41  values ();
    42  
    43  insert into tp_real(c_float, c_double, c_decimal)
    44  values (2020.0202, 2020.0303, 2020.0404);
    45  
    46  insert into tp_other()
    47  values ();
    48  
    49  insert into tp_other(c_enum, c_set, c_bit, c_json)
    50  values ('a', 'a,b', b'1000001', '{
    51    "key1": "value1",
    52    "key2": "value2"
    53  }');
    54  
    55  
    56  create table finish_mark
    57  (
    58      id int PRIMARY KEY
    59  );