github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/tenant/clustertable.sql (about)

     1  set global enable_privilege_cache = off;
     2  drop account if exists tenant_test;
     3  create account tenant_test admin_name = 'root' identified by '111' open comment 'tenant_test';
     4  
     5  use mo_catalog;
     6  drop table if exists a;
     7  create cluster table a(a int);
     8  insert into a values(0, 0),(1, 0),(2, 0),(3, 0);
     9  insert into a values(0, 1),(1, 1),(2, 1),(3, 1);
    10  update a set account_id=(select account_id from mo_account where account_name="tenant_test") where account_id=1;
    11  select a from a;
    12  
    13  -- @session:id=2&user=tenant_test:root&password=111
    14  use mo_catalog;
    15  select a from a;
    16  -- @session
    17  
    18  drop account if exists tenant_test;
    19  
    20  select a from a;
    21  drop table if exists a;
    22  
    23  drop account if exists tenant_test;
    24  set global enable_privilege_cache = on;