github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/function/mo_ctl/mo_ctl_merge.test (about)

     1  drop table if exists t1;
     2  
     3  create table t1(
     4  a int primary key,
     5  b varchar(10)
     6  );
     7  
     8  select mo_ctl('dn', 'inspect', 'policy -r 0 -m 0');
     9  insert into t1 values (100, 'a');
    10  -- @ignore:0
    11  select mo_ctl('dn', 'flush', 'mo_ctl_merge.t1');
    12  insert into t1 values (110, 'a');
    13  -- @ignore:0
    14  select mo_ctl('dn', 'flush', 'mo_ctl_merge.t1');
    15  -- @ignore:0
    16  select mo_ctl('dn', 'mergeobjects', 'mo_ctl_merge.t1:all:small');
    17  -- @bvt:issue#15807
    18  select rows_cnt from metadata_scan('mo_ctl_merge.t1', 'a') g;
    19  -- @bvt:issue
    20  
    21  insert into t1 values (105, 'a');
    22  insert into t1 values (115, 'a');
    23  -- @ignore:0
    24  select mo_ctl('dn', 'flush', 'mo_ctl_merge.t1');
    25  insert into t1 values (120, 'a');
    26  insert into t1 values (125, 'a');
    27  -- @ignore:0
    28  select mo_ctl('dn', 'flush', 'mo_ctl_merge.t1');
    29  -- @ignore:0
    30  select mo_ctl('dn', 'mergeobjects', 'mo_ctl_merge.t1:all:overlap');
    31  -- @bvt:issue#15807
    32  select rows_cnt, bit_cast(`min` as int), bit_cast(`max` as int) from metadata_scan('mo_ctl_merge.t1', 'a') g;
    33  -- @bvt:issue
    34  drop table t1;
    35  
    36  create table t1(
    37  a int,
    38  b varchar(10)
    39  );
    40  insert into t1 values (100, 'a');
    41  -- @ignore:0
    42  select mo_ctl('dn', 'flush', 'mo_ctl_merge.t1');
    43  insert into t1 values (110, 'a');
    44  -- @ignore:0
    45  select mo_ctl('dn', 'flush', 'mo_ctl_merge.t1');
    46  -- @ignore:0
    47  select mo_ctl('dn', 'mergeobjects', 'mo_ctl_merge.t1:all:small');
    48  -- @bvt:issue#15807
    49  select rows_cnt from metadata_scan('mo_ctl_merge.t1', 'a') g;
    50  -- @bvt:issue
    51  
    52  insert into t1 values (105, 'a');
    53  insert into t1 values (115, 'a');
    54  -- @ignore:0
    55  select mo_ctl('dn', 'flush', 'mo_ctl_merge.t1');
    56  insert into t1 values (120, 'a');
    57  insert into t1 values (125, 'a');
    58  -- @ignore:0
    59  select mo_ctl('dn', 'flush', 'mo_ctl_merge.t1');
    60  -- @ignore:0
    61  select mo_ctl('dn', 'mergeobjects', 'mo_ctl_merge.t1:all:overlap');
    62  -- @bvt:issue#15807
    63  select rows_cnt, bit_cast(`min` as int), bit_cast(`max` as int) from metadata_scan('mo_ctl_merge.t1', 'a') g;
    64  -- @bvt:issue
    65  drop table t1;
    66  
    67  create table t1(
    68  a varchar(100) primary key,
    69  b varchar(10)
    70  );
    71  insert into t1 values ('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxya', 'b');
    72  -- @ignore:0
    73  select mo_ctl('dn', 'flush', 'mo_ctl_merge.t1');
    74  insert into t1 values ('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz', 'b');
    75  -- @ignore:0
    76  select mo_ctl('dn', 'flush', 'mo_ctl_merge.t1');
    77  -- @ignore:0
    78  select mo_ctl('dn', 'mergeobjects', 'mo_ctl_merge.t1:all:small');
    79  -- @bvt:issue#15807
    80  select rows_cnt from metadata_scan('mo_ctl_merge.t1', 'a') g;
    81  -- @bvt:issue
    82  
    83  insert into t1 values ('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyb', 'b');
    84  insert into t1 values ('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyc', 'b');
    85  -- @ignore:0
    86  select mo_ctl('dn', 'flush', 'mo_ctl_merge.t1');
    87  insert into t1 values ('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxaa', 'b');
    88  insert into t1 values ('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxab', 'b');
    89  -- @ignore:0
    90  select mo_ctl('dn', 'flush', 'mo_ctl_merge.t1');
    91  -- @ignore:0
    92  select mo_ctl('dn', 'mergeobjects', 'mo_ctl_merge.t1:all:overlap');
    93  -- @bvt:issue#15807
    94  select rows_cnt, min, max from metadata_scan('mo_ctl_merge.t1', 'a') g;
    95  -- @bvt:issue
    96  drop table t1;
    97  
    98  
    99  select mo_ctl('dn', 'inspect', 'policy');