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

     1  drop database if exists priv_db1;
     2  create database priv_db1;
     3  use priv_db1;
     4  show tables;
     5  create table A(a int);
     6  create table B(a int);
     7  show tables;
     8  insert into A values (1),(2),(3),(4);
     9  create view v1_on_A as select A.a from A order by A.a;
    10  select * from v1_on_A;
    11  insert into B select A.a + 1 from A;
    12  select A.a,B.a from A, B where A.a = B.a order by A.a;
    13  update B set a = a + 1;
    14  select A.a,B.a from A, B where A.a = B.a order by A.a;
    15  delete A from A,B where A.a = B.a;
    16  select A.a from A order by a;
    17  drop database if exists priv_db1;