diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/create_view.out | 16 | ||||
| -rw-r--r-- | src/test/regress/expected/join.out | 8 |
2 files changed, 12 insertions, 12 deletions
diff --git a/src/test/regress/expected/create_view.out b/src/test/regress/expected/create_view.out index 32385bbb0ef..9d4f9011a8f 100644 --- a/src/test/regress/expected/create_view.out +++ b/src/test/regress/expected/create_view.out @@ -1976,18 +1976,18 @@ select * from tt24v; ------------------------------------------------------------------------------------------ Hash Join Output: (cte.r).column2, ((ROW("*VALUES*".column1, "*VALUES*".column2))).column2 - Hash Cond: (((ROW("*VALUES*".column1, "*VALUES*".column2))).column1 = (cte.r).column1) + Hash Cond: ((cte.r).column1 = ((ROW("*VALUES*".column1, "*VALUES*".column2))).column1) CTE cte -> Values Scan on "*VALUES*_1" Output: ROW("*VALUES*_1".column1, "*VALUES*_1".column2) - -> Limit - Output: (ROW("*VALUES*".column1, "*VALUES*".column2)) - -> Values Scan on "*VALUES*" - Output: ROW("*VALUES*".column1, "*VALUES*".column2) - -> Hash + -> CTE Scan on cte Output: cte.r - -> CTE Scan on cte - Output: cte.r + -> Hash + Output: (ROW("*VALUES*".column1, "*VALUES*".column2)) + -> Limit + Output: (ROW("*VALUES*".column1, "*VALUES*".column2)) + -> Values Scan on "*VALUES*" + Output: ROW("*VALUES*".column1, "*VALUES*".column2) (14 rows) explain (verbose, costs off) diff --git a/src/test/regress/expected/join.out b/src/test/regress/expected/join.out index 1f0df6b7d94..e1d9d971d65 100644 --- a/src/test/regress/expected/join.out +++ b/src/test/regress/expected/join.out @@ -5207,11 +5207,11 @@ explain (costs off) Sort Key: a.q1, a.q2, x.q1, x.q2, (a.q1) -> Nested Loop -> Seq Scan on int8_tbl a - -> Hash Right Join - Hash Cond: ((a.q1) = x.q2) - -> Seq Scan on int4_tbl y + -> Hash Left Join + Hash Cond: (x.q2 = (a.q1)) + -> Seq Scan on int8_tbl x -> Hash - -> Seq Scan on int8_tbl x + -> Seq Scan on int4_tbl y (9 rows) select * from int8_tbl a, |