github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/tenant/privilege/database.result (about)

     1  drop database if exists priv_db1;
     2  create database priv_db1;
     3  use priv_db1;
     4  show tables;
     5  tables_in_priv_db1
     6  create table A(a int);
     7  create table B(a int);
     8  show tables;
     9  tables_in_priv_db1
    10  a
    11  b
    12  insert into A values (1),(2),(3),(4);
    13  create view v1_on_A as select A.a from A order by A.a;
    14  select * from v1_on_A;
    15  a
    16  1
    17  2
    18  3
    19  4
    20  insert into B select A.a + 1 from A;
    21  select A.a,B.a from A, B where A.a = B.a order by A.a;
    22  a    a
    23  2    2
    24  3    3
    25  4    4
    26  update B set a = a + 1;
    27  select A.a,B.a from A, B where A.a = B.a order by A.a;
    28  a    a
    29  3    3
    30  4    4
    31  delete A from A,B where A.a = B.a;
    32  select A.a from A order by a;
    33  a
    34  1
    35  2
    36  drop database if exists priv_db1;