BUG #17479: "plan should not reference subplan's variable" when calling `grouping` on result of subquery

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: sully(at)msully(dot)net
Subject: BUG #17479: "plan should not reference subplan's variable" when calling `grouping` on result of subquery
Date: 2022-05-10 01:02:35
Message-ID: 17479-6260deceaf0ad304@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17479
Logged by: Michael J. Sullivan
Email address: sully(at)msully(dot)net
PostgreSQL version: 14.2
Operating system: Linux
Description:

The following query produces "plan should not reference subplan's
variable"

create table Card (id uuid);

SELECT
-- This line causes "variable not found in subplan target list"
-- grouping(res.cnt)
-- This line causes "plan should not reference subplan's variable"
(SELECT grouping(res.cnt))
FROM Card
CROSS JOIN LATERAL
(SELECT
(SELECT Card.id) AS cnt
) AS res
GROUP BY
res.cnt

As the comment says, a slight change instead errors with "variable not found
in subplan target list".

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2022-05-10 08:21:02 BUG #17480: Assertion failure in parse_relation.c
Previous Message Miloš Urbánek 2022-05-09 23:26:17 Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*)