From: Tom Lane <tgl@sss.pgh.pa.us>
To: kleptog@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY
Date: Mon, 01 Aug 2022 18:17:11 -0400
Message-ID: <2184335.1659392231@sss.pgh.pa.us> (raw)
In-Reply-To: <17564-c7472c2f90ef2da3@postgresql.org>
References: <17564-c7472c2f90ef2da3@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> db=# explain SELECT generate_subscripts(ARRAY[]::integer[], 1) AS id,
> unnest(ARRAY[]::jsonb[]) ->> 'timestamp' AS timestamp
> FROM results
> JOIN groups ON groups.id = results.group_id
> WHERE results.search_id = 3336
> order by timestamp;
> The error is:
> ERROR: set-valued function called in context that cannot accept a set
> LINE 2: unnest(ARRAY[]::jsonb[]) ->> 'timestamp' AS timestam...
Hmm, that certainly seems like a bug, but I fear it's impossible
to investigate without a reproducible test case.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, kleptog@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY
In-Reply-To: <2184335.1659392231@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox