Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1q15mD-0001Tm-4P
	for pgsql-bugs@arkaria.postgresql.org; Mon, 22 May 2023 13:40:41 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1q15mB-0008OP-6n
	for pgsql-bugs@arkaria.postgresql.org; Mon, 22 May 2023 13:40:39 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1q15mA-0008OE-Uj
	for pgsql-bugs@lists.postgresql.org; Mon, 22 May 2023 13:40:38 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1q15m4-001DY0-1z
	for pgsql-bugs@lists.postgresql.org; Mon, 22 May 2023 13:40:37 +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 34MDeSAu593202;
	Mon, 22 May 2023 09:40:29 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrey Lepikhov <a.lepikhov@postgrespro.ru>
cc: Richard Guo <guofenglinux@gmail.com>, Robert Haas <robertmhaas@gmail.com>,
        PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: Clause accidentally pushed down ( Possible bug in Making Vars
 outer-join aware)
In-reply-to: <32adb59d-e1ea-9ccd-9aac-00677e53b44c@postgrespro.ru>
References: <0b819232-4b50-f245-1c7d-c8c61bf41827@postgrespro.ru>
 <402433.1677524538@sss.pgh.pa.us>
 <2663884e-769a-b298-55b0-014c5a1ee55c@postgrespro.ru>
 <524303.1677538463@sss.pgh.pa.us> <999171.1677611407@sss.pgh.pa.us>
 <CAMbWs4-Pi5cM=V8B-g5Qfnr0t3EgAbhus0YNQN=XquJ8fNoatw@mail.gmail.com>
 <CAMbWs4-Pmh9umsUbfs8Lay=k6wFrsuLdLJ7ci=Af6DqAwsN1Hg@mail.gmail.com>
 <CA+TgmoZ9yQLYziHAbt_X3hpU8FKkPXGLV=OhoD-GejAUckQbrA@mail.gmail.com>
 <CA+TgmoaeccFHN9ouXiSQmMJVh6uF-ANbbDjrwopQ+icYyzJSJw@mail.gmail.com>
 <CAMbWs4_nudsuzd-bLLgu1WCzeV1pLv3SG1Ub8vo-ETJzvgc0Bg@mail.gmail.com>
 <1526312.1683912310@sss.pgh.pa.us> <27! 66442.1684265014@sss.pgh.pa.us>
 <3014965.1684293045@sss.pgh.pa.us>
 <CAMbWs48iJprH69xQ27nigwODu1m_4U3Y2WMTxk47sTVdkW0Seg@mail.gmail.com>
 <3344781.1684337332@sss.pgh.pa.us>
 <CAMbWs4-EU9uBGSP7G-iTwLBhRQ=rnZKvFDhD+n+xhajokyPCKg@mail.gmail.com>
 <3732983.1684416513@sss.pgh.pa.us>
 <CAMbWs49xNW4xU=TQoYhhicvOyK6LLRm1GWr9xDDhCjuaqptWpw@mail.gmail.com>
 <288016.1684522205@sss.pgh.pa.us> <32a!
 db59d-e1ea-9ccd-9aac-00677e53b44c@postgrespro.ru>
Comments: In-reply-to Andrey Lepikhov <a.lepikhov@postgrespro.ru>
	message dated "Mon, 22 May 2023 11:07:23 +0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <593200.1684762828.1@sss.pgh.pa.us>
Date: Mon, 22 May 2023 09:40:28 -0400
Message-ID: <593201.1684762828@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/593201.1684762828%40sss.pgh.pa.us>
Precedence: bulk

Andrey Lepikhov <a.lepikhov@postgrespro.ru> writes:
> Because the feature pushed into the master, I checked it with the 
> sqlancer tests. During all-weekend run no any problems were found.

Thanks for looking!  I strongly suspect that there still are some
problems in this area, but hopefully they are rare enough to go to
beta with.  I'll keep thinking about the issue.

			regards, tom lane