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.98.2) (envelope-from ) id 1xOA3i-00000002xJW-34Zj for pgsql-bugs@arkaria.postgresql.org; Tue, 03 Nov 2026 08:39:59 +0000 Received: from localhost ([127.0.0.1]:44612 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xOA3i-00000008cGg-0li6 for pgsql-bugs@arkaria.postgresql.org; Tue, 03 Nov 2026 08:39:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]:42576) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xOA3h-00000008cGY-3Y7E for pgsql-bugs@lists.postgresql.org; Tue, 03 Nov 2026 08:39:57 +0000 Received: from mail.w14.tutanota.de ([185.205.69.214]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xOA3f-00000002Nc8-3KUK for pgsql-bugs@lists.postgresql.org; Tue, 03 Nov 2026 08:39:57 +0000 Received: from tutadb.w10.tutanota.de (w10.api.tuta.com [IPv6:fd:ac::d:10]) by mail.w14.tutanota.de (Postfix) with ESMTP id 79E291A18A32B for ; Tue, 3 Nov 2026 09:39:54 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; t=1793695194; s=s1; d=rhyadav.dev; h=From:From:To:To:Subject:Subject:Content-Description:Content-ID:Content-Type:Content-Type:Content-Transfer-Encoding:Content-Transfer-Encoding:Cc:Cc:Date:Date:In-Reply-To:In-Reply-To:MIME-Version:MIME-Version:Message-ID:Message-ID:Reply-To:References:References:Sender; bh=6H2S9klvh6bBuzLOTRzvdkRaoU3HxOZLZNGnJkqw8mI=; b=BfuGGPYQeMVqLrS48P3rrK6ou32dYWYr+fUZgZXNSkRva/6w4BSmabGxGSzUSTBp ssODvO/FgitywtxaU67iqvCiEpkaDvSu+Shin0mW7Xq4U8YRtkvp3ycHRBX5r3UhgXI EF2gm2UVTQUPSctINnelwUpBsgJ8WXXs3WjOMdX20vOhzczwqxyCpBeWFK/3dMbAEg9 8tUkSHSFTx1CskB9HZ9o7NZQzcZHUkgdRGEtwu23rt2Wdt3fVc598O+kNDxmJ8YFzDp vUjmpdnvBBbRaAYWD4vfHVblZ1bwXeY4W4L+DxYIX0MRChG1njVpkYr9GBnHn1/WRsj uyZBFgfwCA== Date: Tue, 3 Nov 2026 09:39:54 +0100 (CET) From: Rahul To: Richard Guo Cc: shihao zhong , Alexandra Wang , Samuel Olaoye , Pgsql Bugs Message-ID: In-Reply-To: References: <179087936257.78721.1170374394656748858@mail.gmail.com> Subject: Re: Wrong results: hashed SubPlan referenced twice after OR-qual extraction reuses a stale hash table (13 to 19beta4) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Feedback-ID: 01f8c5108c48fea26a092a077590a8fcdbfcdbb733bc38e3db5db9540fc242b99227bb05256e786b1fc713cdb05f073377d63f8aec9e32cbf77d26f42c5d89118b:TurnOnPrivacy!:tutamail List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Richard, On Mon, Nov 2, 2026, Richard Guo wrote: > Done. Thanks for reviewing, committing and back-patching it, and for taking care of the ABI check.=C2=A0 The simpler test and the rewritten comments are clear improvements, and I'll keep both points in mind for future patches. Thanks also to Alex and Shihao for reviewing, and to Samuel for the report. Regards, Rahul Yadav