diff options
| author | Tomas Vondra | 2017-10-08 17:28:41 +0000 |
|---|---|---|
| committer | Tomas Vondra | 2017-10-08 17:28:41 +0000 |
| commit | ea34783b8c01f8396ae1b576a117f69d27e1e381 (patch) | |
| tree | 8cd72c7fe88f408b57c3621aaf9617fda1c8a794 | |
| parent | a3aba68733f07477f77c15aa890d06b558863703 (diff) | |
Accept plan changes in 'limit' test suite
The accepted plan changes seem correct, as the only difference with
respect to upstream plans is Limit distribution. The commit diff is
a bit more complicated, because the expected plan did not reflect
the switch from Result to ProjectSet.
| -rw-r--r-- | src/test/regress/expected/limit.out | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/src/test/regress/expected/limit.out b/src/test/regress/expected/limit.out index 0af7e2f0c9..503bdda0e1 100644 --- a/src/test/regress/expected/limit.out +++ b/src/test/regress/expected/limit.out @@ -397,8 +397,8 @@ select currval('testseq'); explain (verbose, costs off) select unique1, unique2, generate_series(1,10) from tenk1 order by unique2 limit 7; - QUERY PLAN ----------------------------------------------------------------------- + QUERY PLAN +------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Limit Output: unique1, unique2, (generate_series(1, 10)) -> Remote Subquery Scan on all (datanode_1,datanode_2) @@ -406,9 +406,11 @@ select unique1, unique2, generate_series(1,10) Sort Key: tenk1.unique2 -> Limit Output: unique1, unique2, (generate_series(1, 10)) - -> Index Scan using tenk1_unique2 on public.tenk1 + -> ProjectSet Output: unique1, unique2, generate_series(1, 10) -(9 rows) + -> Index Scan using tenk1_unique2 on public.tenk1 + Output: unique1, unique2, two, four, ten, twenty, hundred, thousand, twothousand, fivethous, tenthous, odd, even, stringu1, stringu2, string4 +(11 rows) select unique1, unique2, generate_series(1,10) from tenk1 order by unique2 limit 7; @@ -435,7 +437,7 @@ select unique1, unique2, generate_series(1,10) Sort Key: tenk1.tenthous -> Limit Output: unique1, unique2, (generate_series(1, 10)), tenthous - -> Result + -> ProjectSet Output: unique1, unique2, generate_series(1, 10), tenthous -> Sort Output: unique1, unique2, tenthous |