firtst release
| Revision | de6e936d0302c520b27b5c3bea35c357355eeb52 (tree) |
|---|---|
| Time | 2019-01-07 18:57:53 |
| Author | Kyotaro Horiguchi <horiguchi.kyotaro@lab....> |
| Commiter | Kyotaro Horiguchi |
Adjust regression test
Core behavior has changed, adjust regression test.
expected/pg_hint_plan.out (diff) output/ut-fdw.source (diff)| @@ -11,13 +11,13 @@ EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id; | ||
| 11 | 11 | (4 rows) |
| 12 | 12 | |
| 13 | 13 | EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.val = t2.val; |
| 14 | - QUERY PLAN | |
| 15 | -------------------------------------------- | |
| 16 | - Merge Join | |
| 17 | - Merge Cond: (t2.val = t1.val) | |
| 18 | - -> Index Scan using t2_val on t2 | |
| 19 | - -> Materialize | |
| 20 | - -> Index Scan using t1_val on t1 | |
| 14 | + QUERY PLAN | |
| 15 | +-------------------------------- | |
| 16 | + Hash Join | |
| 17 | + Hash Cond: (t2.val = t1.val) | |
| 18 | + -> Seq Scan on t2 | |
| 19 | + -> Hash | |
| 20 | + -> Seq Scan on t1 | |
| 21 | 21 | (5 rows) |
| 22 | 22 | |
| 23 | 23 | LOAD 'pg_hint_plan'; |
| @@ -32,13 +32,13 @@ EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id; | ||
| 32 | 32 | (4 rows) |
| 33 | 33 | |
| 34 | 34 | EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.val = t2.val; |
| 35 | - QUERY PLAN | |
| 36 | -------------------------------------------- | |
| 37 | - Merge Join | |
| 38 | - Merge Cond: (t2.val = t1.val) | |
| 39 | - -> Index Scan using t2_val on t2 | |
| 40 | - -> Materialize | |
| 41 | - -> Index Scan using t1_val on t1 | |
| 35 | + QUERY PLAN | |
| 36 | +-------------------------------- | |
| 37 | + Hash Join | |
| 38 | + Hash Cond: (t2.val = t1.val) | |
| 39 | + -> Seq Scan on t2 | |
| 40 | + -> Hash | |
| 41 | + -> Seq Scan on t1 | |
| 42 | 42 | (5 rows) |
| 43 | 43 | |
| 44 | 44 | /*+ Test (t1 t2) */ |
| @@ -132,17 +132,17 @@ error hint: | ||
| 132 | 132 | |
| 133 | 133 | \o |
| 134 | 134 | \! sql/maskout.sh results/ut-fdw.tmpout |
| 135 | - Nested Loop (cost=xxx rows=1 width=xxx) | |
| 135 | + Nested Loop (cost=xxx..xxx rows=1 width=xxx) | |
| 136 | 136 | Join Filter: (ft_1.id = t1.c1) |
| 137 | - -> Nested Loop (cost=xxx rows=1 width=xxx) | |
| 137 | + -> Nested Loop (cost=xxx..xxx rows=1 width=xxx) | |
| 138 | 138 | Join Filter: (ft_1.id = ft_2.id) |
| 139 | - -> Foreign Scan on ft1 ft_1 (cost=xxx rows=1 width=xxx) | |
| 139 | + -> Foreign Scan on ft1 ft_1 (cost=xxx..xxx rows=1 width=xxx) | |
| 140 | 140 | Foreign File: @abs_srcdir@/data/data.csv |
| 141 | 141 | Foreign File Size: 42 b |
| 142 | - -> Foreign Scan on ft1 ft_2 (cost=xxx rows=1 width=xxx) | |
| 142 | + -> Foreign Scan on ft1 ft_2 (cost=xxx..xxx rows=1 width=xxx) | |
| 143 | 143 | Foreign File: @abs_srcdir@/data/data.csv |
| 144 | 144 | Foreign File Size: 42 b |
| 145 | - -> Index Scan using t1_i1 on t1 (cost=xxx rows=1 width=xxx) | |
| 145 | + -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1 width=xxx) | |
| 146 | 146 | Index Cond: (c1 = ft_2.id) |
| 147 | 147 | |
| 148 | 148 | \! rm results/ut-fdw.tmpout |
amalsyah1
Fork