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 1tt4bL-008ISU-6C for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Mar 2025 12:57:23 +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 1tt4bJ-006hHS-Ks for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Mar 2025 12:57:21 +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.94.2) (envelope-from ) id 1tt0AE-001B9y-QK for pgsql-bugs@lists.postgresql.org; Fri, 14 Mar 2025 08:13:06 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tt0AC-002lm5-3D for pgsql-bugs@lists.postgresql.org; Fri, 14 Mar 2025 08:13:05 +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=L0JaEJdAgp6JvJcuTje5frd+WRngEOv4dmJA1XvdZgw=; b=5aBAaBZE+y1WmOzDFQnDj6itRK Di+7THXzyiWilkyVG/cytJTP2dDail2zGIcYvPh++9WKpjttabUoxUQo4JsufNnUa8cl4dW7g7iUz i5Ky73f6qOE/LoT+M4QA+AhPV6knZZ6HnDOvau4CP95W343A4opxLi5csMvv3WBday9FpgNI9VK1i 1v7MLyf2RhFZXdGdDE/MSlvlTDbWUTlJHHUuWL5L7Avt0HnqLBeokvUz/fa/ib0x8tFmdpO+Q5kDh k3RKdAbv0hP8r8qfVAd/+TjvrNPP0D0K/VN9uiUwFpwwhx8Y9TksiuTz+hpjM0y3KjB6uDuk+gLsi zM0niDXQ==; 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 1tt0AC-0079lK-Gs for pgsql-bugs@lists.postgresql.org; Fri, 14 Mar 2025 08:13:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tt0AB-00GXIg-Gi for pgsql-bugs@lists.postgresql.org; Fri, 14 Mar 2025 08:13:02 +0000 Content-Type: multipart/mixed; boundary="===============4790948610600865190==" MIME-Version: 1.0 Subject: BUG #18847: Different Query Results with and without a Primary Key Constraint To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: cheng.zhi.qiang@outlook.com Reply-To: cheng.zhi.qiang@outlook.com, pgsql-bugs@lists.postgresql.org Date: Fri, 14 Mar 2025 08:12:43 +0000 Message-ID: <18847-692e3ecb7fa1d870@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 --===============4790948610600865190== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODg0NwpMb2dnZWQgYnk6ICAgICAgICAgIHpoaXFpYW5nIGNoZW5nCkVt YWlsIGFkZHJlc3M6ICAgICAgY2hlbmcuemhpLnFpYW5nQG91dGxvb2suY29tClBvc3RncmVTUUwg dmVyc2lvbjogMTYuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMC4wNApEZXNjcmlwdGlv bjogICAgICAgIAoKRGVzY3JpcHRpb246DQpXaGVuIGV4ZWN1dGluZyBhIFJJR0hUIEpPSU4gcXVl cnkgaW52b2x2aW5nIG11bHRpcGxlIHRhYmxlcywgdGhlIHByZXNlbmNlIG9yCmFic2VuY2Ugb2Yg YSBwcmltYXJ5IGtleSBjb25zdHJhaW50IG9uIG9uZSBvZiB0aGUgdGFibGVzICh0MikgYWZmZWN0 cyB0aGUKcXVlcnkgcmVzdWx0LiBUaGUgZXhwZWN0YXRpb24gaXMgdGhhdCBhZGRpbmcgb3IgcmVt b3ZpbmcgYW4gaW5kZXggb3IKY29uc3RyYWludCBzaG91bGQgbm90IGNoYW5nZSB0aGUgbG9naWNh bCBxdWVyeSByZXN1bHQsIHlldCBpbiB0aGlzIGNhc2UsIHRoZQpxdWVyeSByZXR1cm5zIGRpZmZl cmVudCByZXN1bHRzLg0KDQpTdGVwcyB0byBSZXByb2R1Y2U6DQpDcmVhdGUgdGVzdCB0YWJsZXMg YW5kIGluc2VydCBkYXRhOg0KQ1JFQVRFIFRBQkxFIHQwICgNCiAgICBjMCBudW1lcmljLA0KICAg IGMxIHRpbWVzdGFtcCB3aXRob3V0IHRpbWUgem9uZQ0KKTsNCg0KSU5TRVJUIElOVE8gdDAgKGMw LCBjMSkgVkFMVUVTDQooMC4wLCAnMTk4MC0xMi0yNCAxNjowMjo1MCcpOw0KDQpDUkVBVEUgVEFC TEUgdDEgKA0KICAgIGMyIG51bWVyaWMsDQogICAgYzMgdGltZXN0YW1wIHdpdGhvdXQgdGltZSB6 b25lLA0KICAgIGM0IGludGVnZXINCik7DQoNCklOU0VSVCBJTlRPIHQxIChjMiwgYzMsIGM0KSBW QUxVRVMNCiggLTQuOCwgJzIwMjYtMTItMTEgMDM6MzU6NTEnLDUpOw0KDQpDUkVBVEUgVEFCTEUg dDIgKA0KICAgIGM1IGludGVnZXINCik7DQoNCklOU0VSVCBJTlRPIHQyIChjNSkgVkFMVUVTDQoo MSk7DQoNCnF1ZXJ5MSAod2l0aCBwcmltYXJ5IGtleSBjb25zdHJhaW50IG9uIHQyKToNCkFMVEVS IFRBQkxFIE9OTFkgdDINCiAgICBBREQgQ09OU1RSQUlOVCB0Ml9rZXkgUFJJTUFSWSBLRVkgKGM1 KTsNCg0Kc2VsZWN0IA0KICByZWZfMS5jMSBhcyBjXzEsIA0KICByZWZfMi5jMyBhcyBjXzINCmZy b20gDQogICgoKHNlbGVjdCAgDQogICAgICAgICAgICAxIGFzIGNfMQ0KICAgICAgICAgICBGUk9N ICh0MiByZWZfMA0KICAgICAgICAgICAgIFJJR0hUIEpPSU4gdDEgcmVmXzMgT04gKChyZWZfMC5j NSA9IHJlZl8zLmM0KSkpDQogICAgICAgICAgIGFzIHJlZl80DQogICAgICAgICAgICApIGFzIHN1 YnFfMA0KICAgICAgcmlnaHQgIGpvaW4gdDAgYXMgcmVmXzENCiAgICAgIG9uIChzdWJxXzAuY18x ID0gcmVmXzEuYzAgKSkNCiAgICByaWdodCAgam9pbiB0MSBhcyByZWZfMg0KICAgIG9uIChzdWJx XzAuY18xID0gcmVmXzIuYzIgKSkNCndoZXJlICggKCAoKHJlZl8xLmMxKSA8PSAocmVmXzIuYzMp KSkpOw0KDQpvdXRwdXQ6DQogICAgICAgICBjXzEgICAgICAgICB8ICAgICAgICAgY18yICAgICAg ICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogMTk4MC0x Mi0yNCAxNjowMjo1MCB8IDIwMjYtMTItMTEgMDM6MzU6NTENCigxIHJvdykNCg0KcXVlcnkyIChE cm9wIHRoZSBwcmltYXJ5IGtleSBjb25zdHJhaW50LGV4ZWN1dGUgdGhlIHNhbWUgcXVlcnkgYWdh aW4pOg0KQUxURVIgVEFCTEUgT05MWSB0Mg0KICAgIERST1AgQ09OU1RSQUlOVCB0Ml9rZXk7DQoN CnNlbGVjdCANCiAgcmVmXzEuYzEgYXMgY18xLCANCiAgcmVmXzIuYzMgYXMgY18yDQpmcm9tIA0K ICAoKChzZWxlY3QgIA0KICAgICAgICAgICAgMSBhcyBjXzENCiAgICAgICAgICAgRlJPTSAodDIg cmVmXzANCiAgICAgICAgICAgICBSSUdIVCBKT0lOIHQxIHJlZl8zIE9OICgocmVmXzAuYzUgPSBy ZWZfMy5jNCkpKQ0KICAgICAgICAgICBhcyByZWZfNA0KICAgICAgICAgICAgKSBhcyBzdWJxXzAN CiAgICAgIHJpZ2h0ICBqb2luIHQwIGFzIHJlZl8xDQogICAgICBvbiAoc3VicV8wLmNfMSA9IHJl Zl8xLmMwICkpDQogICAgcmlnaHQgIGpvaW4gdDEgYXMgcmVmXzINCiAgICBvbiAoc3VicV8wLmNf MSA9IHJlZl8yLmMyICkpDQp3aGVyZSAoICggKChyZWZfMS5jMSkgPD0gKHJlZl8yLmMzKSkpKTsN Cg0Kb3V0cHV0Og0KIGNfMSB8IGNfMiANCi0tLS0tKy0tLS0tDQooMCByb3dzKSAgIA0KDQpFeHBl Y3RlZCBiZWhhdmlvcjoNClJlZ2FyZGxlc3Mgb2Ygd2hldGhlciBhbiBpbmRleCBpcyBhZGRlZCBv ciBub3QsIHRoZSByZXN1bHRzIG9mIHRoZSBxdWVyeQpzaG91bGQgbm90IGNoYW5nZQ0KDQpBY3R1 YWwgYmVoYXZpb3I6DQpxdWVyeSByZXN1bHRzIGNoYW5nZWQNCg0KUG9zdGdyZXMgdmVyc2lvbjoN CkdpdGh1YiBjb21taXQ6IDNmMWFhYWExODA2ODlmMjAxNWU3ZjdiZDAxYzliZTZkN2E5OTNiNDIN ClZlcnNpb246ICBQb3N0Z3JlU1FMIDE2YmV0YTEgb24geDg2XzY0LXBjLWxpbnV4LWdudSwgY29t cGlsZWQgYnkgZ2NjCihVYnVudHUNCjkuNC4wLTF1YnVudHUxfjIwLjA0LjIpIDkuNC4wLCA2NC1i aXQNCg0KT3BlcmF0aW5nIHN5c3RlbToNCkxpbnV4IHVidW50dSA1LjE1LjAtMTM0LWdlbmVyaWMg IzE0NX4yMC4wNC4xLVVidW50dSBTTVAgTW9uIEZlYiAxNwoxMzoyNzoxNg0KVVRDIDIwMjUgeDg2 XzY0IHg4Nl82NCB4ODZfNjQgR05VL0xpbnV4Cgo= --===============4790948610600865190==--