Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1wEuDA-004Xmr-1J
	for pgsql-bugs@arkaria.postgresql.org;
	Mon, 20 Apr 2026 19:23:12 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1wEuD9-004N1X-1i
	for pgsql-bugs@arkaria.postgresql.org;
	Mon, 20 Apr 2026 19:23:11 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1wEuD9-004N1O-0t
	for pgsql-bugs@lists.postgresql.org;
	Mon, 20 Apr 2026 19:23:11 +0000
Received: from sss.pgh.pa.us ([68.162.161.243])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1wEuD6-00000001y5Z-3okh
	for pgsql-bugs@lists.postgresql.org;
	Mon, 20 Apr 2026 19:23:10 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 63KJN8BQ420866;
	Mon, 20 Apr 2026 15:23:08 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-bugs@lists.postgresql.org
cc: Richard Guo <guofenglinux@gmail.com>, francois.jehl@pigment.com,
        Robert Haas <robertmhaas@gmail.com>
Subject: Re: BUG #19460: FULL JOIN rewriting issue on empty queries
In-reply-to: <418974.1776711680@sss.pgh.pa.us>
References: <19460-5625143cef66012f@postgresql.org> <53936.1776633020@sss.pgh.pa.us> <CAMbWs48E2qqd4B6AdvJDyPBi685-_bDEvoe0aJnYzAPL1v30zg@mail.gmail.com> <81857.1776648374@sss.pgh.pa.us> <CAMbWs49PPxhrqBjHj3Wy4hK4=_DoHkJdAHL_q1mqpyyCk5MdMw@mail.gmail.com> <88899.1776652344@sss.pgh.pa.us> <CAMbWs4_nNfYktwQu4vNbienz+6oKXeE1Vzq9K_qH9F19MaJoMQ@mail.gmail.com> <418974.1776711680@sss.pgh.pa.us>
Comments: In-reply-to Tom Lane <tgl@sss.pgh.pa.us>
	message dated "Mon, 20 Apr 2026 15:01:20 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <420864.1776712988.1@sss.pgh.pa.us>
Date: Mon, 20 Apr 2026 15:23:08 -0400
Message-ID: <420865.1776712988@sss.pgh.pa.us>
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: <https://www.postgresql.org/message-id/420865.1776712988%40sss.pgh.pa.us>
Precedence: bulk

I wrote:
> Pushed at cfcd57111 et al.  Thanks again for the report!

Hmm, skink seems unhappy with this.  Looking...

			regards, tom lane