BUG #17832: ERROR: failed to apply nullingrels to a non-Var in HEAD

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: marko(at)joh(dot)to
Subject: BUG #17832: ERROR: failed to apply nullingrels to a non-Var in HEAD
Date: 2023-03-11 18:05:20
Message-ID: 17832-d0a8106cdf1b722e@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: 17832
Logged by: Marko Tiikkaja
Email address: marko(at)joh(dot)to
PostgreSQL version: Unsupported/Unknown
Operating system: Linux
Description:

Running the following query in HEAD fails with the error in $SUBJECT:

SELECT 1
FROM
(
SELECT NULL::text AS AccountName
) Actual FULL JOIN (
SELECT text 'foo'
UNION ALL
SELECT text 'bar'
) Expected (AccountName)
ON TRUE
WHERE Expected.AccountName IS NULL;

I tried PGv15 online and it seemed to work there, so I'm guessing this only
applies to HEAD.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dean Rasheed 2023-03-11 18:12:29 Re: BUG #17809: MERGE ... UPDATE fails with BEFORE ROW UPDATE trigger when target row updated concurrently
Previous Message Tom Lane 2023-03-11 17:23:56 Re: BUG #17826: An assert failed in /src/backend/optimizer/util/var.c