github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/table/temporary_table/various_test.sql (about)

     1  -- @skip:issue#7889
     2  drop database if exists test_temporary;
     3  create database test_temporary;
     4  use test_temporary;
     5  create temporary table t1(
     6  col1 tinyint,
     7  col2 smallint,
     8  col3 int,
     9  col4 bigint,
    10  col5 tinyint unsigned,
    11  col6 smallint unsigned,
    12  col7 int unsigned,
    13  col8 bigint unsigned
    14  );
    15  
    16  -- @bvt:issue#7875
    17  -- load data
    18  load data infile '$resources/load_data/integer_numbers_1.csv' into table t1 fields terminated by ',';
    19  select * from t1;
    20  
    21  -- into outfile
    22  select * from t1 into outfile '$resources/into_outfile_2/outfile_integer_numbers_2.csv';
    23  delete from t1;
    24  
    25  -- load data
    26  load data infile '$resources/into_outfile_2/outfile_integer_numbers_2.csv' into table t1 fields terminated by ',' ignore 1 lines;
    27  select * from t1;
    28  delete from t1;
    29  
    30  load data infile '$resources/load_data/integer_numbers_2.csv' into table t1 fields terminated by'*';
    31  select * from t1;
    32  delete from t1;
    33  drop table t1;
    34  -- @bvt:issue