github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/pessimistic_transaction/special.result (about)

     1  drop database if exists special;
     2  create database special;
     3  use special;
     4  set @@autocommit = 1;
     5  create table t(a int primary key);
     6  insert into t select * from generate_series(1,200000) g;
     7  select count(*) from t;
     8  count(*)
     9  200000
    10  insert into t select * from t;
    11  (Duplicate entry)([\d\D]*)(for key 'a')
    12  begin;
    13  insert into t select * from t;
    14  (Duplicate entry)([\d\D]*)(for key 'a')
    15  select count(*) from t;
    16  count(*)
    17  200000
    18  commit;
    19  select count(*) from t;
    20  count(*)
    21  200000
    22  begin;
    23  use special;
    24  create external table ex_table_dis(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19)) infile{"filepath"='$resources/external_table_file/ex_table_number.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n';
    25  select num_col1,num_col2 from ex_table_dis;
    26  num_col1    num_col2
    27  60    -1000
    28  -128    -32768
    29  127    32767
    30  null    null
    31  use special;
    32  select * from ex_table_dis;
    33  SQL parser error: table "ex_table_dis" does not exist
    34  update ex_table_dis set num_col1=1000;
    35  invalid input: cannot insert/update/delete from external table
    36  select num_col1,num_col2 from ex_table_dis;
    37  num_col1    num_col2
    38  60    -1000
    39  -128    -32768
    40  127    32767
    41  null    null
    42  commit;
    43  select num_col1,num_col2 from ex_table_dis;
    44  num_col1    num_col2
    45  60    -1000
    46  -128    -32768
    47  127    32767
    48  null    null
    49  drop database if exists special;