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

     1  drop database if exists test_temporary;
     2  create database test_temporary;
     3  use test_temporary;
     4  create temporary table t (a int);
     5  create table t1 (a int);
     6  show tables;
     7  tables_in_temporary_table
     8  t1
     9  insert into t values (1), (2), (3);
    10  select * from t;
    11  a
    12  1
    13  2
    14  3
    15  delete from t where a = 1;
    16  select * from t;
    17  a
    18  2
    19  3
    20  update t set a = 4 where a = 3;
    21  select * from t;
    22  a
    23  2
    24  4
    25  insert into t1 values (100);
    26  insert into t select * from t1;
    27  select * from t;
    28  a
    29  2
    30  4
    31  100
    32  drop database if exists test_temporary2;
    33  create database test_temporary2;
    34  use test_temporary2;
    35  create temporary table t (a int);
    36  create table t1 (a int);
    37  select * from t;
    38  a
    39  drop table t;
    40  select * from test_temporary.t;
    41  a
    42  2
    43  4
    44  100
    45  drop database if exists test_temporary;
    46  drop database if exists test_temporary2;
    47  drop database if exists test_tmp;
    48  create database test_tmp;
    49  use test_tmp;
    50  drop table if exists f1;
    51  drop table if exists t1;
    52  create table f1 (a int primary key);
    53  create temporary table  t1 (a int primary key);
    54  create temporary table c1(a int, constraint ck foreign key(a) REFERENCES f1(a));
    55  add foreign key for temporary table is not yet implemented
    56  create table c1(a int, constraint ck foreign key(a) REFERENCES t1(a));
    57  add foreign key for temporary table is not yet implemented
    58  drop table if exists f1;
    59  drop table if exists t1;
    60  drop database if exists test_tmp;