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

     1  create table fake_pk(id int);
     2  insert into fake_pk(id) values(1);
     3  select * from fake_pk order by id;
     4  id
     5  1
     6  insert into fake_pk(id) values(2);
     7  select * from fake_pk order by id;
     8  id
     9  1
    10  2
    11  insert into fake_pk values(3);
    12  select * from fake_pk order by id;
    13  id
    14  1
    15  2
    16  3
    17  update fake_pk set id = 11 where id = 1;
    18  select * from fake_pk order by id;
    19  id
    20  2
    21  3
    22  11
    23  delete from fake_pk where id = 1;
    24  select * from fake_pk order by id;
    25  id
    26  2
    27  3
    28  11
    29  create table fake_pk_with_cluster_by(id int, v int) cluster by (id);
    30  insert into fake_pk_with_cluster_by values(1,1);
    31  select * from fake_pk_with_cluster_by order by id;
    32  id    v
    33  1    1
    34  update fake_pk_with_cluster_by set v = 10 where id = 1;
    35  select * from fake_pk_with_cluster_by order by id;
    36  id    v
    37  1    10
    38  create table fake_pk_with_multi_cluster_by(id int, v int) cluster by (id, v);
    39  insert into fake_pk_with_multi_cluster_by values(1,1);
    40  select * from fake_pk_with_multi_cluster_by order by id;
    41  id    v
    42  1    1
    43  update fake_pk_with_multi_cluster_by set v = 10 where id = 1;
    44  select * from fake_pk_with_multi_cluster_by order by id;
    45  id    v
    46  1    10