Re: ERROR: wrong varnullingrels (b 5 7) (expected (b)) for Var 3/3 - Mailing list pgsql-hackers

From Richard Guo
Subject Re: ERROR: wrong varnullingrels (b 5 7) (expected (b)) for Var 3/3
Date
Msg-id CAMbWs49iDiGsXWuMj-9-LLW4ANWUoXeK+VHRcpqJe08YimbYyQ@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: wrong varnullingrels (b 5 7) (expected (b)) for Var 3/3  (Michael Paquier <michael@paquier.xyz>)
Responses Re: ERROR: wrong varnullingrels (b 5 7) (expected (b)) for Var 3/3
List pgsql-hackers

On Fri, May 19, 2023 at 1:57 PM Michael Paquier <michael@paquier.xyz> wrote:
Thanks for the test case, issue reproduced here on HEAD and not v15.
This causes an assertion failure here:
#4  0x000055a6f8faa776 in ExceptionalCondition (conditionName=0x55a6f915ac60 "bms_equal(rel->relids, root->all_query_rels)", fileName=0x55a6f915ac3d "allpaths.c",
    lineNumber=234) at assert.c:66
#5  0x000055a6f8c55b6d in make_one_rel (root=0x55a6fa814ea8, joinlist=0x55a6fa83f758) at allpaths.c:234
#6  0x000055a6f8c95c45 in query_planner (root=0x55a6fa814ea8, qp_callback=0x55a6f8c9c373 <standard_qp_callback>, qp_extra=0x7ffc98138570) at planmain.c:278
#7  0x000055a6f8c9860a in grouping_planner (root=0x55a6fa814ea8, tuple_fraction=0) at planner.c:1493

I am adding an open item.

Thanks for testing.  I looked into it and figured out that it is the
same issue discussed at the end of this thread:
https://www.postgresql.org/message-id/CAMbWs4-EU9uBGSP7G-iTwLBhRQ%3DrnZKvFDhD%2Bn%2BxhajokyPCKg%40mail.gmail.com

Thanks
Richard

pgsql-hackers by date:

Previous
From: Hans Buschmann
Date:
Subject: PG 16 draft release notes ready
Next
From: "Drouvot, Bertrand"
Date:
Subject: Re: Introduce WAIT_EVENT_EXTENSION and WAIT_EVENT_BUFFER_PIN