github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/set/set_operator.test (about)

     1  -- @suite
     2  -- @setup
     3  
     4  drop table if exists t1;
     5  drop table if exists t2;
     6  create table t1 (a smallint, b bigint, c int);
     7  insert into t1 values (1,2,3);
     8  insert into t1 values (1,2,3);
     9  insert into t1 values (3,4,5);
    10  insert into t1 values (4,5,6);
    11  insert into t1 values (4,5,6);
    12  insert into t1 values (1,1,2);
    13  create table t2 (a smallint, b bigint, c int);
    14  insert into t2 values (1,2,3);
    15  insert into t2 values (3,4,5);
    16  insert into t2 values (1,2,1);
    17  
    18  -- @case
    19  -- @desc:test for set operators
    20  -- @label:bvt
    21  
    22  select * from t1 minus select * from t2;
    23  select * from t1 intersect select * from t2;
    24  select a, b from t1 minus select b, c from t2;
    25  select a, b from t1 intersect select b, c from t2;
    26  set max_allowed_packet = cast('2048' as unsigned);
    27  show variables where variable_name = 'max_allowed_packet';
    28  set @val = cast('2022-10-10' as date);
    29  select @val;