-> Function Scan on generate_series

(7 rows)

-- Disallow pushing down sort when pathkey is an SRF.

explain (costs off) select unique1 from tenk1 order by unnest('{1,2}'::int[]);

QUERY PLAN

-------------------------------------------------------------------------

Sort

Sort Key: (unnest('{1,2}'::integer[]))

-> Gather

Workers Planned: 2

-> ProjectSet

-> Parallel Index Only Scan using tenk1_unique1 on tenk1

(6 rows)

-> Result

(16 rows)

-- must disallow pushing sort below gather when pathkey contains an SRF

EXPLAIN (VERBOSE, COSTS OFF)

SELECT unnest(ARRAY[]::integer[]) + 1 AS pathkey

FROM tenk1 t1 JOIN tenk1 t2 ON TRUE

ORDER BY pathkey;

QUERY PLAN

-----------------------------------------------------------------------------------------------------

Sort

Output: (((unnest('{}'::integer[])) + 1))

Sort Key: (((unnest('{}'::integer[])) + 1))

-> Result

Output: ((unnest('{}'::integer[])) + 1)

-> ProjectSet

Output: unnest('{}'::integer[])

-> Nested Loop

-> Gather

Workers Planned: 4

-> Parallel Index Only Scan using tenk1_hundred on public.tenk1 t1

-> Materialize

-> Gather

Workers Planned: 4

-> Parallel Index Only Scan using tenk1_hundred on public.tenk1 t2

(15 rows)

-- test passing expanded-value representations to workers

CREATE FUNCTION make_some_array(int,int) returns int[] as

$$declare x int[];

explain (costs off)selectsub.unique1, stringu1|| random()::text

from tenk1, lateral (selecttenk1.unique1from generate_series(1,1000))as sub

order by1,2;

explain (costs off)select unique1from tenk1order by unnest('{1,2}'::int[]);

SELECT generate_series(1, two), array(select generate_series(1, two))

FROM tenk1ORDER BY tenthous;

EXPLAIN (VERBOSE, COSTS OFF)

SELECT unnest(ARRAY[]::integer[])+1AS pathkey

FROM tenk1 t1JOIN tenk1 t2ON TRUE

ORDER BY pathkey;

CREATEFUNCTIONmake_some_array(int,int) returnsint[]as

$$declare xint[];