github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/table/temporary_table/simple_test.sql (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  -- test Temporary tables are not displayed when show table
     7  show tables;
     8  insert into t values (1), (2), (3);
     9  select * from t;
    10  delete from t where a = 1;
    11  select * from t;
    12  update t set a = 4 where a = 3;
    13  select * from t;
    14  insert into t1 values (100);
    15  insert into t select * from t1;
    16  select * from t;
    17  drop database if exists test_temporary2;
    18  create database test_temporary2;
    19  use test_temporary2;
    20  create temporary table t (a int);
    21  create table t1 (a int);
    22  select * from t;
    23  drop table t;
    24  select * from test_temporary.t;
    25  drop database if exists test_temporary;
    26  drop database if exists test_temporary2;