BUG #17832: ERROR: failed to apply nullingrels to a non-Var in HEAD - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #17832: ERROR: failed to apply nullingrels to a non-Var in HEAD
Date
Msg-id 17832-d0a8106cdf1b722e@postgresql.org
Whole thread Raw
Responses Re: BUG #17832: ERROR: failed to apply nullingrels to a non-Var in HEAD  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      17832
Logged by:          Marko Tiikkaja
Email address:      marko@joh.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.


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #17826: An assert failed in /src/backend/optimizer/util/var.c
Next
From: Dean Rasheed
Date:
Subject: Re: BUG #17809: MERGE ... UPDATE fails with BEFORE ROW UPDATE trigger when target row updated concurrently