add test for set operator
@@ -295,4 +295,14 @@ CREATE FUNCTION notnull1 AS (p) -> not(is_null(p));
SELECT notnull1(null);
SELECT notnull1('null');
+--set operator
+select '====Intersect Distinct===';
+create table t1(a int, b int);
+create table t2(c int, d int);
+insert into t1 values(1, 2), (2, 3), (3 ,4), (2, 3);
+insert into t2 values(2,2), (3, 5), (7 ,8), (2, 3), (3, 4);
+select * from t1 intersect select * from t2;
+select '====Except Distinct===';
+select * from t1 except select * from t2;
+
set enable_planner_v2 = 0;
