github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/fake_pk/fake.sql (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  insert into fake_pk(id) values(2);
     5  select * from fake_pk order by id;
     6  insert into fake_pk values(3);
     7  select * from fake_pk order by id;
     8  update fake_pk set id = 11 where id = 1;
     9  select * from fake_pk order by id;
    10  delete from fake_pk where id = 1;
    11  select * from fake_pk order by id;
    12  
    13  
    14  create table fake_pk_with_cluster_by(id int, v int) cluster by (id);
    15  insert into fake_pk_with_cluster_by values(1,1);
    16  select * from fake_pk_with_cluster_by order by id;
    17  update fake_pk_with_cluster_by set v = 10 where id = 1;
    18  select * from fake_pk_with_cluster_by order by id;
    19  
    20  create table fake_pk_with_multi_cluster_by(id int, v int) cluster by (id, v);
    21  insert into fake_pk_with_multi_cluster_by values(1,1);
    22  select * from fake_pk_with_multi_cluster_by order by id;
    23  update fake_pk_with_multi_cluster_by set v = 10 where id = 1;
    24  select * from fake_pk_with_multi_cluster_by order by id;