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

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