Phoenix Tips (14) mutable 和 immutable 表区别

分别创建表：

 create table my_mutable (id varchar not null primary key, cf1.a varchar , cf1.b varchar, cf2.c varchar, cf2.d varchar) ;

 create table my_immutable (id varchar not null primary key, cf1.a varchar , cf1.b varchar, cf2.c varchar, cf2.d varchar) immutable_rows=true ;

分别创建索引：

create index index_my_mutable on my_mutable(a,c) include (b,d);

create index index_my_immutable on my_immutable(a,c) include (b,d);

分别插入数据

  upsert into my_mutable values ('1000001','a1','b1','c1','d1');
  upsert into my_mutable values ('1000001','a2','b2','c2','d2');
  upsert into my_mutable values ('1000001','a3','b3','c3','d3');

  upsert into my_immutable values ('1000001','a1','b1','c1','d1');
  upsert into my_immutable values ('1000001','a2','b2','c2','d2');
  upsert into my_immutable values ('1000001','a3','b3','c3','d3');

查看数据：

select * from my_mutable ;
-----------------------------------------------------------------
|     ID            |     A      |     B        |     C       |     D        |
-----------------------------------------------------------------
| 1000001    | a3         | b3         | c3         | d3          |
-----------------------------------------------------------------
 
 select * from my_immutable ;
 ---------------------------------------------------------------
|     ID            |     A      |     B        |     C      |     D        |
----------------------------------------------------------------
| 1000001    | a1         | b1         | c1         | d1         |
| 1000001    | a2         | b2         | c2         | d2         |
| 1000001    | a3         | b3         | c3         | d3         |
----------------------------------------------------------------
 
 select * from index_my_mutable ;
---------------------------------------------------------------------------
|   CF1:A    |   CF2:C    |    :ID            |   CF1:B    |   CF2:D    |
---------------------------------------------------------------------------
| a3            | c3              | 1000001    | b3            | d3             |
---------------------------------------------------------------------------
 
 select * from index_my_immutable ;
---------------------------------------------------------------------------
|   CF1:A    |   CF2:C    |    :ID            |   CF1:B    |   CF2:D    |
---------------------------------------------------------------------------
| a1             | c1             | 1000001    | b1            | d1             |
| a2             | c2             | 1000001    | b2            | d2             |
| a3             | c3             | 1000001    | b3            | d3             |
---------------------------------------------------------------------------