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

     1  create table t1(
     2  id int,
     3  data varchar(64)
     4  );
     5  replace into t1 values (1, 'new_1');
     6  select * from t1;
     7  id    data
     8  1    new_1
     9  replace into t1 values (1, 'new_2');
    10  select * from t1;
    11  id    data
    12  1    new_1
    13  1    new_2
    14  replace into t1 values (1, 'new_1');
    15  select * from t1;
    16  id    data
    17  1    new_1
    18  1    new_2
    19  1    new_1
    20  create table t2(
    21  id int,
    22  data varchar(64),
    23  primary key (id)
    24  );
    25  replace into t2 values (1, 'test_1');
    26  select * from t2;
    27  id    data
    28  1    test_1
    29  replace into t2 values (2, 'test_1');
    30  select * from t2;
    31  id    data
    32  1    test_1
    33  2    test_1
    34  replace into t2 values (1, 'old_1');
    35  select * from t2;
    36  id    data
    37  2    test_1
    38  1    old_1
    39  replace into t2 values (2, 'old_2');
    40  select * from t2;
    41  id    data
    42  1    old_1
    43  2    old_2
    44  create table t3(
    45  id int,
    46  data varchar(64),
    47  name varchar(64) default null,
    48  primary key (id, data)
    49  );
    50  replace into t3 values (1, 'test_3', '');
    51  select * from t3;
    52  id    data    name
    53  1    test_3    
    54  replace into t3 values (1, 'old_3', 'name1');
    55  select * from t3;
    56  id    data    name
    57  1    test_3    
    58  1    old_3    name1
    59  replace into t3 values (2, 'test_3', 'name2');
    60  select * from t3;
    61  id    data    name
    62  1    test_3    
    63  1    old_3    name1
    64  2    test_3    name2
    65  replace into t3 values (1, 'test_3', 'replace_name_1');
    66  select * from t3;
    67  id    data    name
    68  1    old_3    name1
    69  2    test_3    name2
    70  1    test_3    replace_name_1
    71  replace into t3 values (2, 'test_3', 'replace_name_2');
    72  select * from t3;
    73  id    data    name
    74  1    old_3    name1
    75  1    test_3    replace_name_1
    76  2    test_3    replace_name_2
    77  create table t4 (
    78  a int unique key,
    79  b varchar(64)
    80  );
    81  replace into t4 values (1, 'a');
    82  select * from t4;
    83  a    b
    84  1    a
    85  replace into t4 values (2, 'a');
    86  select * from t4;
    87  a    b
    88  1    a
    89  2    a
    90  replace into t4 values (1, 'replace_name_1');
    91  select * from t4;
    92  a    b
    93  2    a
    94  1    replace_name_1
    95  replace into t4 values (2, 'replace_name_2');
    96  select * from t4;
    97  a    b
    98  1    replace_name_1
    99  2    replace_name_2
   100  create table t5(
   101  a int,
   102  b int,
   103  c varchar(64),
   104  unique key(a, b)
   105  );
   106  replace into t5 values (1, 1, '');
   107  select * from t5;
   108  a    b    c
   109  1    1
   110  replace into t5 values (1, 1, 'replace');
   111  select * from t5;
   112  a    b    c
   113  1    1    replace
   114  replace into t5 values (1, 2, '');
   115  select * from t5;
   116  a    b    c
   117  1    1    replace
   118  1    2
   119  drop table if exists t1;
   120  drop table if exists t2;
   121  drop table if exists t3;
   122  drop table if exists t4;
   123  drop table if exists t5;