diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/join.out | 6 | ||||
| -rw-r--r-- | src/test/regress/sql/join.sql | 4 |
2 files changed, 5 insertions, 5 deletions
diff --git a/src/test/regress/expected/join.out b/src/test/regress/expected/join.out index 1e3fe073504..8c17ef41b92 100644 --- a/src/test/regress/expected/join.out +++ b/src/test/regress/expected/join.out @@ -3074,14 +3074,14 @@ select f1, unique2, case when unique2 is null then f1 else 0 end explain (costs off) select a.unique1, b.unique1, c.unique1, coalesce(b.twothousand, a.twothousand) from tenk1 a left join tenk1 b on b.thousand = a.unique1 left join tenk1 c on c.unique2 = coalesce(b.twothousand, a.twothousand) - where a.unique2 = 5530 and coalesce(b.twothousand, a.twothousand) = 44; + where a.unique2 < 10 and coalesce(b.twothousand, a.twothousand) = 44; QUERY PLAN --------------------------------------------------------------------------------------------- Nested Loop Left Join -> Nested Loop Left Join Filter: (COALESCE(b.twothousand, a.twothousand) = 44) -> Index Scan using tenk1_unique2 on tenk1 a - Index Cond: (unique2 = 5530) + Index Cond: (unique2 < 10) -> Bitmap Heap Scan on tenk1 b Recheck Cond: (thousand = a.unique1) -> Bitmap Index Scan on tenk1_thous_tenthous @@ -3092,7 +3092,7 @@ select a.unique1, b.unique1, c.unique1, coalesce(b.twothousand, a.twothousand) select a.unique1, b.unique1, c.unique1, coalesce(b.twothousand, a.twothousand) from tenk1 a left join tenk1 b on b.thousand = a.unique1 left join tenk1 c on c.unique2 = coalesce(b.twothousand, a.twothousand) - where a.unique2 = 5530 and coalesce(b.twothousand, a.twothousand) = 44; + where a.unique2 < 10 and coalesce(b.twothousand, a.twothousand) = 44; unique1 | unique1 | unique1 | coalesce ---------+---------+---------+---------- (0 rows) diff --git a/src/test/regress/sql/join.sql b/src/test/regress/sql/join.sql index 7a08bdff7bf..db7aefee283 100644 --- a/src/test/regress/sql/join.sql +++ b/src/test/regress/sql/join.sql @@ -880,11 +880,11 @@ select f1, unique2, case when unique2 is null then f1 else 0 end explain (costs off) select a.unique1, b.unique1, c.unique1, coalesce(b.twothousand, a.twothousand) from tenk1 a left join tenk1 b on b.thousand = a.unique1 left join tenk1 c on c.unique2 = coalesce(b.twothousand, a.twothousand) - where a.unique2 = 5530 and coalesce(b.twothousand, a.twothousand) = 44; + where a.unique2 < 10 and coalesce(b.twothousand, a.twothousand) = 44; select a.unique1, b.unique1, c.unique1, coalesce(b.twothousand, a.twothousand) from tenk1 a left join tenk1 b on b.thousand = a.unique1 left join tenk1 c on c.unique2 = coalesce(b.twothousand, a.twothousand) - where a.unique2 = 5530 and coalesce(b.twothousand, a.twothousand) = 44; + where a.unique2 < 10 and coalesce(b.twothousand, a.twothousand) = 44; -- -- check handling of join aliases when flattening multiple levels of subquery |