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 ) id 1qBJaF-00035Y-Ve for pgsql-bugs@arkaria.postgresql.org; Mon, 19 Jun 2023 18:26:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qBJaE-0005Vt-94 for pgsql-bugs@arkaria.postgresql.org; Mon, 19 Jun 2023 18:26:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qBJAx-0001Jx-5R for pgsql-bugs@lists.postgresql.org; Mon, 19 Jun 2023 18:00:27 +0000 Received: from mailg210.ethz.ch ([2001:67c:10ec:5606::21]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qBJAu-003TA5-1z for pgsql-bugs@lists.postgresql.org; Mon, 19 Jun 2023 18:00:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=inf.ethz.ch; s=key1-q2-2022; t=1687197621; h=From:Subject:Date:Message-ID:To:Cc :MIME-Version:Content-Type:In-Reply-To:References; bh=qcge7uqJl3RDVFlLD4w dddaSHxrswTyAKogInBsU3yg=; b=M+ylzXxiBMhd4xX1HgeTTdk5XBo7k1FM66LSJEzm2bkB IaJ0kob5Vl8CY6BM6eJoxuVUwUn2w4ovWedc6ZFU+gVwa0qJqEj2WaJEymHjKjx9xuD6IN3Ye TrWSRCV0v3SihWwNpd6OofV2d+/2hIAxiMJZzPCoyyJr4vNJhxTZLZGnIphKOepvqXFIQY+gi Deu9GlzvWd4LaIrTKYKPLM2gUBKeRoaT+2Mb1pQpPG1oPsAzAsK3blQt3uFLi34Ugfnm9HEAa anwCL+c9/ZFftSMfHI40cl2nLSHQ5UcONt5E07z1hV22y5PxPXIovtD4FHm25OU1VwHZO45+W 5QrT0g==; Received: from mailm211.d.ethz.ch (2001:67c:10ec:5603::25) by mailg210.ethz.ch (2001:67c:10ec:5606::21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2507.27; Mon, 19 Jun 2023 20:00:21 +0200 Received: from [192.168.1.35] (77.109.152.204) by mailm211.d.ethz.ch (2001:67c:10ec:5603::25) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2507.23; Mon, 19 Jun 2023 20:00:21 +0200 Content-Type: multipart/alternative; boundary="------------JqIl9Mmg0dEQSVttBPT9ariF" Message-ID: <5d183639-dbc5-e6be-39bd-6ada253c5ece@inf.ethz.ch> Date: Mon, 19 Jun 2023 20:00:20 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Thunderbird/102.12.0 Subject: Re: BUG #17982: Inconsistent results of SELECT with CTE caused by subquery comparison To: Tom Lane CC: References: <17982-3fa239feecd6c1b3@postgresql.org> <2980037.1687190927@sss.pgh.pa.us> Content-Language: en-US From: Zu-Ming Jiang In-Reply-To: <2980037.1687190927@sss.pgh.pa.us> X-Originating-IP: [77.109.152.204] X-ClientProxiedBy: mailm217.d.ethz.ch (2001:67c:10ec:5603::31) To mailm211.d.ethz.ch (2001:67c:10ec:5603::25) X-DKIM-Signer: DkimX (v3.20.320) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --------------JqIl9Mmg0dEQSVttBPT9ariF Content-Type: text/plain; charset="UTF-8"; format=flowed Content-Transfer-Encoding: 7bit Thanks for your information and the fixing! I will then apply your patch and test postgres again. Best, Zuming ------------------------------------------------------------------------ *From:* Tom Lane [mailto:tgl@sss.pgh.pa.us] *Sent:* Monday, June 19, 2023 at 6:08 PM *To:* zuming.jiang@inf.ethz.ch *Cc:* pgsql-bugs@lists.postgresql.org *Subject:* BUG #17982: Inconsistent results of SELECT with CTE caused by subquery comparison > PG Bug reporting form writes: >> My fuzzer finds a correctness bug in Postgres, which makes Postgres return >> inconsistent results. > This appears to be the same issue you already reported in bug #17978. > At least, the patch I just posted in that thread fixes this too. > > regards, tom lane --------------JqIl9Mmg0dEQSVttBPT9ariF Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: 7bit Thanks for your information and the fixing! I will then apply your patch and test postgres again.

Best,
Zuming

From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, June 19, 2023 at 6:08 PM
Subject: BUG #17982: Inconsistent results of SELECT with CTE caused by subquery comparison

PG Bug reporting form <noreply@postgresql.org> writes:

My fuzzer finds a correctness bug in Postgres, which makes Postgres return
inconsistent results.

This appears to be the same issue you already reported in bug #17978.
At least, the patch I just posted in that thread fixes this too.

			regards, tom lane

--------------JqIl9Mmg0dEQSVttBPT9ariF--