github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/tenant/privilege/database.test (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  create table A(a int);
     7  create table B(a int);
     8  show tables;
     9  insert into A values (1),(2),(3),(4);
    10  create view v1_on_A as select A.a from A order by A.a;
    11  select * from v1_on_A;
    12  insert into B select A.a + 1 from A;
    13  select A.a,B.a from A, B where A.a = B.a order by A.a;
    14  update B set a = a + 1;
    15  select A.a,B.a from A, B where A.a = B.a order by A.a;
    16  delete A from A,B where A.a = B.a;
    17  select A.a from A order by a;
    18  drop database if exists priv_db1;
    19  set global enable_privilege_cache = on;