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

     1  drop table if exists t1;
     2  drop table if exists t2;
     3  create table t1 (a smallint, b bigint, c int);
     4  insert into t1 values (1,2,3);
     5  insert into t1 values (1,2,3);
     6  insert into t1 values (3,4,5);
     7  insert into t1 values (4,5,6);
     8  insert into t1 values (4,5,6);
     9  insert into t1 values (1,1,2);
    10  create table t2 (a smallint, b bigint, c int);
    11  insert into t2 values (1,2,3);
    12  insert into t2 values (3,4,5);
    13  insert into t2 values (1,2,1);
    14  select * from t1 minus select * from t2;
    15  a	b	c
    16  1	1	2
    17  4	5	6
    18  select * from t1 intersect select * from t2;
    19  a	b	c
    20  1	2	3
    21  3	4	5
    22  select a, b from t1 minus select b, c from t2;
    23  a	b
    24  3	4
    25  1	1
    26  1	2
    27  select a, b from t1 intersect select b, c from t2;
    28  a	b
    29  4	5
    30  set max_allowed_packet = cast('2048' as unsigned);
    31  show variables where variable_name = 'max_allowed_packet';
    32  Variable_name    Value
    33  max_allowed_packet    2048
    34  set @val = cast('2022-10-10' as date);
    35  select @val;
    36  @val
    37  2022-10-10