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.94.2) (envelope-from ) id 1vCenv-00GhtQ-Cs for pgsql-bugs@arkaria.postgresql.org; Sat, 25 Oct 2025 13:59:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vCemv-0032sh-9K for pgsql-bugs@arkaria.postgresql.org; Sat, 25 Oct 2025 13:58:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vCIiA-00H5KM-H6 for pgsql-bugs@lists.postgresql.org; Fri, 24 Oct 2025 14:24:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vCIi7-0040R9-0W for pgsql-bugs@lists.postgresql.org; Fri, 24 Oct 2025 14:24:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=EYT6Pe9LAYshM/lnFjxvTzg2ui2z1GNi/VISaUDQiWM=; b=h2GwhJjWg6D129QfyS9+yMDdEe iAnbYo3R+pUHH0zevYyfEcnPBnzUqEFnrDKSG2uzvIcpzmy3mGvsHoMCVxY5yz/c5l885oQOisjy0 ZeyZshOAMxz904VnXSMHsuDLf8ZVtpiLamkMuGiw5wXjPgZSd54yf33hOLOVR/fXeP3xF4z7X9Gyj Xb1qa9Ha5i/P9TD7NPZ0WaTei3Dx+5vP5tp3++jp9MULXhvH4wx9gILmNMiY+QLIolIne3MgZxp2h bZOkY/uvUqTpXoRP5F61a4A4du1KMamK/mftvzfA00wR2YL3C/LSU0Sk1JX13kg8K7yWv3Ke9BmWI NuL5d9AQ==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vCIi6-004iAC-3m for pgsql-bugs@lists.postgresql.org; Fri, 24 Oct 2025 14:24:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vCIi3-00D7ic-0K for pgsql-bugs@lists.postgresql.org; Fri, 24 Oct 2025 14:24:03 +0000 Content-Type: multipart/mixed; boundary="===============4334480248401940973==" MIME-Version: 1.0 Subject: BUG #19094: select statement on postgres 17 vs postgres 18 is returning different/duplicate results To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: lori.corbani@jax.org Reply-To: lori.corbani@jax.org, pgsql-bugs@lists.postgresql.org Date: Fri, 24 Oct 2025 14:23:34 +0000 Message-ID: <19094-6ed410eb5b256abd@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4334480248401940973== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA5NApMb2dnZWQgYnk6ICAgICAgICAgIExvcmkgQ29yYmFuaQpFbWFp bCBhZGRyZXNzOiAgICAgIGxvcmkuY29yYmFuaUBqYXgub3JnClBvc3RncmVTUUwgdmVyc2lvbjog MTguMApPcGVyYXRpbmcgc3lzdGVtOiAgIFJvY2t5IExpbnV4IDkuNiAoQmx1ZSBPbnl4KQpEZXNj cmlwdGlvbjogICAgICAgIAoKcG9zdGdyZXMgMTc6ICAoQSkgU0VMRUNUIDExNTQ1NywgKEIpIFNF TEVDVCAxMTU0NTcgOiBzYW1lIGNvdW50cwoKcG9zdGdyZXMgMTg6ICAoQSkgU0VMRUNUIDExNTQ0 NCwgIChCKSBTRUxFQ1QgMTE1NDM2IDogZGlmZmVyZW50IGNvdW50cwoKSSBhbSBydW5uaW5nIHRo aXMgZnJvbSAvdXNyL3Bnc3FsLTE4L2Jpbi9wc3FsCgpzdGVwIDE6ICBwc3FsIC1oICR7UEdfREJT RVJWRVJ9IC1VICR7UEdfREJVU0VSfSAtZCAke1BHX0RCTkFNRX0gLWUKc3RlcCAyOiBydW4gKEEp IHZlcnNpb24gLyB3aXRob3V0IHRoZSAiZGlzdGluY3QiIGNsYXVzZQpzdGVwIDM6IHNlbGVjdCBy ZXN1bHRzCnN0ZXAgNDogZXhpdCBwc3FsCnN0ZXAgNS4gcmVwZWF0IHN0ZXAgMS00CgplYWNoIHRp bWUgSSBydW4gInBnc3FsIiBhbmQgdGhlIHNhbWUgU1FMLCBJIGdldCBhIGRpZmZlcmVudCBjb3Vu dC4Kc29tZXRpbWVzIHRoZSBjb3VudCBnb2VzIHVwIGFuZCBzb21ldGltZXMgdGhlIGNvdW50IGdv ZXMgZG93bi4KCnJ1bm5pbmcgdGhlIFNRTCB3aXRoIHRoZSAiZGlzdGluY3QiIGZpeGVzIHRoZSBw cm9ibGVtLCBidXQgd2UgYXJlIG5vdCBoYXZpbmcKdGhpcyBwcm9ibGVtIG9uIHBvc3RncmVzIDE3 LgpQb3N0Z3JlcyAxNyBjb25zaXN0ZW50bHkgcmV0dXJucyB0aGUgc2FtZSBjb3VudC4KCldoZW4g d2UgbWlncmF0ZWQgZnJvbSBQb3N0Z3JlcyAxNyB0byBQb3N0Z3JlcyAxOCwgSSB1c2VkIHRoZSBz YW1lCiJwb3N0Z3Jlc3NxbC5jb25mIiBhbmQgInBnX2hwYS5jb25maWciLgpBbHNvLCB3ZSBtaWdy YXRlZCBmcm9tIFBvc3RncmVzIDE1IHRvIFBvc3RncmVzIDE3IGVhcmxpZXIgdGhpcyB5ZWFyIHdp dGggbm8KaXNzdWVzOyB1c2luZyB0aGUgc2FtZSBtZXRob2QuCgpJZiBJIHJlbW92ZSB0aGUgImV4 aXN0cyIgc3RhdGVtZW50LCB0aGVuIHRoZSBjb3VudHMgYXJlIGZpbmUuClNvLCBpdCBzZWVtcyB0 aGF0IGl0IGlzIHRoZSAiZXhpc3RzIiBzdGF0ZW1lbnQgdGhhdCBpcyBjYXVzaW5nIHRoZSBpc3N1 ZS4KCiJzZWxlY3Qgcy5fU3RyYWluX2tleSIgICAgIFZTICAic2VsZWN0IGRpc3RpbmN0IHMuX1N0 cmFpbl9rZXkiCgogICAgICAgIGZyb20gcHJiX3N0cmFpbiBzCiAgICAgICAgd2hlcmUgcy5wcml2 YXRlID0gMAogICAgICAgICAgICBhbmQgcy5zdHJhaW4gbm90IGlsaWtlICclaW52b2x2ZXMlJwog ICAgICAgICAgICBhbmQgcy5zdHJhaW4gbm90IGlsaWtlICclZWl0aGVyJScKICAgICAgICAgICAg YW5kIHMuc3RyYWluIG5vdCBpbGlrZSAnJSBhbmQgJScKICAgICAgICAgICAgYW5kIHMuc3RyYWlu IG5vdCBpbGlrZSAnJSBvciAlJwogICAgICAgICAgICBhbmQgZXhpc3RzIChzZWxlY3QgMSBmcm9t IHZvY19hbm5vdCB2YSwgdm9jX3Rlcm0gdAogICAgICAgICAgICAgICAgd2hlcmUgdmEuX0Fubm90 VHlwZV9rZXkgPSAxMDA5CiAgICAgICAgICAgICAgICBhbmQgdmEuX1Rlcm1fa2V5ID0gdC5fVGVy bV9rZXkKICAgICAgICAgICAgICAgIGFuZCB0LnRlcm0gIT0gJ05vdCBBcHBsaWNhYmxlJwogICAg ICAgICAgICAgICAgYW5kIHQudGVybSAhPSAnTm90IFNwZWNpZmllZCcKICAgICAgICAgICAgICAg IGFuZCB2YS5fT2JqZWN0X2tleSA9IHMuX1N0cmFpbl9rZXkpCgo= --===============4334480248401940973==--