diff options
Diffstat (limited to 'src/test/regress/expected/inherit.out')
| -rw-r--r-- | src/test/regress/expected/inherit.out | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/src/test/regress/expected/inherit.out b/src/test/regress/expected/inherit.out index cc3670bd914..8520281f750 100644 --- a/src/test/regress/expected/inherit.out +++ b/src/test/regress/expected/inherit.out @@ -1350,6 +1350,47 @@ ORDER BY x, y; -> Index Only Scan using tenk1_unique2 on tenk1 b (6 rows) +-- exercise rescan code path via a repeatedly-evaluated subquery +explain (costs off) +SELECT + (SELECT g.i FROM ( + (SELECT * FROM generate_series(1, 2) ORDER BY 1) + UNION ALL + (SELECT * FROM generate_series(1, 2) ORDER BY 1) + ) f(i) + ORDER BY f.i LIMIT 1) +FROM generate_series(1, 3) g(i); + QUERY PLAN +------------------------------------------------------------------------------------ + Function Scan on generate_series g + SubPlan 1 + -> Limit + -> Result + -> Merge Append + Sort Key: generate_series.generate_series + -> Sort + Sort Key: generate_series.generate_series + -> Function Scan on generate_series + -> Sort + Sort Key: generate_series_1.generate_series + -> Function Scan on generate_series generate_series_1 +(12 rows) + +SELECT + (SELECT g.i FROM ( + (SELECT * FROM generate_series(1, 2) ORDER BY 1) + UNION ALL + (SELECT * FROM generate_series(1, 2) ORDER BY 1) + ) f(i) + ORDER BY f.i LIMIT 1) +FROM generate_series(1, 3) g(i); + i +--- + 1 + 2 + 3 +(3 rows) + reset enable_seqscan; reset enable_indexscan; reset enable_bitmapscan; |