Support DECLARE CURSOR syntax and added regression for table hinting.

[pghintplan/pg_hint_plan.git] / output / ut-fdw.source

diff --git a/output/ut-fdw.source b/output/ut-fdw.source
index 247b9b3..4907980 100644 (file)
--- a/output/ut-fdw.source
+++ b/output/ut-fdw.source
@@ -116,7 +116,7 @@ error hint:
 ---- No. R-1-6 object type for the hint
 ----
 -- No. R-1-6-6
-\o results/R_1-6-6.out.log
+\o results/ut-fdw.tmpout
 /*+Rows(ft_1 ft_2 #1)Leading(ft_1 ft_2 t1)*/
 EXPLAIN SELECT * FROM s1.t1, ft1 ft_1, ft1 ft_2 WHERE t1.c1 = ft_1.id AND t1.c1 = ft_2.id;
 LOG:  pg_hint_plan:
@@ -128,6 +128,17 @@ duplication hint:
 error hint:
 
 \o
-\! sed 's/cost=[\.0-9]*/cost=xxx/' results/R_1-6-6.out.log > results/R_1-6-6.out_2.log
-\! sed 's/Foreign File: .*/Foreign File: @pg_hint_plan@\/data\/data.csv/' results/R_1-6-6.out_2.log > results/R_1-6-6.out
-\! diff expected/R_1-6-6.out results/R_1-6-6.out
+\! sql/maskout.sh results/ut-fdw.tmpout
+ Nested Loop  (cost=xxx rows=1 width=xxx)
+   ->  Nested Loop  (cost=xxx rows=1 width=xxx)
+         Join Filter: (ft_1.id = ft_2.id)
+         ->  Foreign Scan on ft1 ft_1  (cost=xxx rows=1 width=xxx)
+               Foreign File: @abs_srcdir@/data/data.csv
+               Foreign File Size: 42
+         ->  Foreign Scan on ft1 ft_2  (cost=xxx rows=1 width=xxx)
+               Foreign File: @abs_srcdir@/data/data.csv
+               Foreign File Size: 42
+   ->  Index Scan using t1_i1 on t1  (cost=xxx rows=1 width=xxx)
+         Index Cond: (c1 = ft_1.id)
+
+\! rm results/ut-fdw.tmpout