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

     1  set global enable_privilege_cache = off;
     2  drop account if exists acc1;
     3  create account acc1 admin_name = 'r1' identified by '111' open comment 'acc1';
     4  use mo_catalog;
     5  drop table if exists a;
     6  CREATE CLUSTER TABLE a (`id` varchar(128) NOT NULL,
     7  `name` VARCHAR(255) NOT NULL,
     8  `account_name` varchar(128) NOT NULL,
     9  PRIMARY KEY (`id`),
    10  UNIQUE INDEX `uniq_acc` (`account_name`));
    11  insert into a values (0,"abc","acc1",1);
    12  insert into a values (1,"bcd","acc2",1);
    13  update a set account_id=(select account_id from mo_account where account_name="acc1") where account_id=1;
    14  use mo_catalog;
    15  select * from a;
    16  id    name    account_name
    17  0    abc    acc1
    18  1    bcd    acc2
    19  update a set `account_name` = "cde" where id = 1;
    20  update a set `account_name` = "cde" where id = 1;
    21  update a set `name` = "xxx" where `account_name` = "cde";
    22  update a set `id` = 3 where `id` = 1;
    23  update a set `id` = 3, `account_name`='qwe' where `id` = 3;
    24  delete from a where `id` = 1;
    25  use mo_catalog;
    26  select * from a;
    27  id    name    account_name
    28  0    abc    acc1
    29  3    xxx    qwe
    30  drop table if exists a;
    31  drop account if exists acc1;
    32  set global enable_privilege_cache = on;