diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/join.out | 1 | ||||
| -rw-r--r-- | src/test/regress/sql/join.sql | 2 |
2 files changed, 3 insertions, 0 deletions
diff --git a/src/test/regress/expected/join.out b/src/test/regress/expected/join.out index c94ac614af8..d46ff26d82b 100644 --- a/src/test/regress/expected/join.out +++ b/src/test/regress/expected/join.out @@ -2713,6 +2713,7 @@ where thousand = (q1 + q2); -- -- test placement of movable quals in a parameterized join tree -- +set effective_cache_size = '128MB'; explain (costs off) select * from tenk1 t1 left join (tenk1 t2 join tenk1 t3 on t2.thousand = t3.unique2) diff --git a/src/test/regress/sql/join.sql b/src/test/regress/sql/join.sql index 351400f2da2..1a4dc03d18b 100644 --- a/src/test/regress/sql/join.sql +++ b/src/test/regress/sql/join.sql @@ -711,6 +711,8 @@ where thousand = (q1 + q2); -- test placement of movable quals in a parameterized join tree -- +set effective_cache_size = '128MB'; + explain (costs off) select * from tenk1 t1 left join (tenk1 t2 join tenk1 t3 on t2.thousand = t3.unique2) |