github.com/matrixorigin/matrixone@v0.7.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;