Add into unsupported.sql test on 'not executed' problem.

danolivo · Andrey Lepikhov · commit b0d8a3330219 · 2021-07-12T09:10:19.000+05:00
diff --git a/expected/unsupported.out b/expected/unsupported.out
@@ -304,4 +304,39 @@ EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
  JOINS: 0
 (22 rows)
 
+--
+-- Not executed nodes
+--
+SELECT * FROM
+	(SELECT * FROM t WHERE x < 0) AS t0
+		JOIN
+	(SELECT * FROM t WHERE x > 20) AS t1
+		USING(x);
+ x 
+---
+(0 rows)
+
+EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
+SELECT * FROM
+	(SELECT * FROM t WHERE x < 0) AS t0
+		JOIN
+	(SELECT * FROM t WHERE x > 20) AS t1
+		USING(x);
+                   QUERY PLAN                   
+------------------------------------------------
+ Hash Join (actual rows=0 loops=1)
+   AQO not used
+   Hash Cond: (t.x = t_1.x)
+   ->  Seq Scan on t (actual rows=0 loops=1)
+         AQO not used
+         Filter: (x < 0)
+         Rows Removed by Filter: 1000
+   ->  Hash (never executed)
+         ->  Seq Scan on t t_1 (never executed)
+               Filter: (x > 20)
+ Using aqo: true
+ AQO mode: LEARN
+ JOINS: 0
+(13 rows)
+
 DROP EXTENSION aqo;
diff --git a/sql/unsupported.sql b/sql/unsupported.sql
@@ -61,4 +61,19 @@ EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
 	SELECT count(*) FROM t WHERE (SELECT avg(x) FROM t t0 WHERE t0.x = t.x) =
 	(SELECT avg(x) FROM t t0 WHERE t0.x = t.x);
 
+--
+-- Not executed nodes
+--
+SELECT * FROM
+	(SELECT * FROM t WHERE x < 0) AS t0
+		JOIN
+	(SELECT * FROM t WHERE x > 20) AS t1
+		USING(x);
+EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
+SELECT * FROM
+	(SELECT * FROM t WHERE x < 0) AS t0
+		JOIN
+	(SELECT * FROM t WHERE x > 20) AS t1
+		USING(x);
+
 DROP EXTENSION aqo;
