github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/table/temporary_table/various_test.result (about)

     1  drop database if exists test_temporary;
     2  create database test_temporary;
     3  use test_temporary;
     4  create temporary table t1(
     5  col1 tinyint,
     6  col2 smallint,
     7  col3 int,
     8  col4 bigint,
     9  col5 tinyint unsigned,
    10  col6 smallint unsigned,
    11  col7 int unsigned,
    12  col8 bigint unsigned
    13  );
    14  import data infile '$resources/load_data/integer_numbers_1.csv' into table t1;
    15  select * from t1;
    16  col1    col2    col3    col4    col5    col6    col7    col8
    17  127    32767    2147483647    9223372036854775807    255    65535    4294967295    18446744073709551615
    18  -128    -32768    -2147483648    -9223372036854775808    0    0    0    0
    19  0    0    0    0    0    0    0    0
    20  null    null    null    null    null    null    null    null
    21  1    null    null    0    0    0    null    null
    22  null    null    null    null    null    null    null    null
    23  127    32767    2147483647    9223372036854775807    255    65535    4294967295    18446744073709551615
    24  select * from t1 into outfile '$resources/into_outfile_2/outfile_integer_numbers_2.csv';
    25  col1    col2    col3    col4    col5    col6    col7    col8
    26  delete from t1;
    27  import data infile '$resources/into_outfile_2/outfile_integer_numbers_2.csv' into table t1 ignore 1 lines;
    28  select * from t1;
    29  col1    col2    col3    col4    col5    col6    col7    col8
    30  127    32767    2147483647    9223372036854775807    255    65535    4294967295    18446744073709551615
    31  -128    -32768    -2147483648    -9223372036854775808    0    0    0    0
    32  0    0    0    0    0    0    0    0
    33  null    null    null    null    null    null    null    null
    34  1    null    null    0    0    0    null    null
    35  null    null    null    null    null    null    null    null
    36  127    32767    2147483647    9223372036854775807    255    65535    4294967295    18446744073709551615
    37  delete from t1;
    38  import data infile '$resources/load_data/integer_numbers_2.csv' into table t1 fields terminated by'*';
    39  select * from t1;
    40  col1    col2    col3    col4    col5    col6    col7    col8
    41  127    32767    2147483647    9223372036854775807    255    65535    4294967295    18446744073709551615
    42  -128    -32768    -2147483648    -9223372036854775808    0    0    0    0
    43  0    0    0    0    0    0    0    0
    44  null    null    null    null    null    null    null    null
    45  1    null    null    0    0    0    null    null
    46  null    null    null    null    null    null    null    null
    47  127    32767    2147483647    9223372036854775807    255    65535    4294967295    18446744073709551615
    48  delete from t1;
    49  drop table t1;