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

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