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 1sbEDg-00EyyY-9B for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Aug 2024 07:02:56 +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 1sbECf-006YB0-Jq for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Aug 2024 07:01:53 +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 1sbDcC-005csU-3i for pgsql-bugs@lists.postgresql.org; Tue, 06 Aug 2024 06:24:12 +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.94.2) (envelope-from ) id 1sbDc7-003Pou-QN for pgsql-bugs@lists.postgresql.org; Tue, 06 Aug 2024 06:24:11 +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=MGrsq7Zl3A1fVrM4GorelvNU7Ee/mHye3hQV+IWQn4M=; b=vWoo68Wlic2uQE+xq8eTXflkFa oY/Y+YBQ0Qyr+czG4pyC4ix32+u9jJgocZWFR7SIgJJxFfc3Ejfhp66YMr3bgksqbRMg2kEjTfmX8 NwXNF2a7HRqhAuTxQ2zL7EOBJedPXYtI9r26e7f/Q2bqlGC4a83xoBzgGgspDXaCxsosYyePZ6b7L KynwwOFVb6YThEH/mjxe6EuRky6/uDiSHqVagoWDX7Sy290nroh7AlQKd6jWo+zE6C2hvRrfF7fIV Xak2SNcwBljQLxCln50+yiI+V+0r+PMFZGnmKXiePUt1FeKby/+XmFaLquS/dTjPAbfrYPTKKhV6Z Q07NZvQw==; 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 1sbDc4-00AN5z-KP for pgsql-bugs@lists.postgresql.org; Tue, 06 Aug 2024 06:24:06 +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 1sbDc1-00GWBC-S8 for pgsql-bugs@lists.postgresql.org; Tue, 06 Aug 2024 06:24:02 +0000 Content-Type: multipart/mixed; boundary="===============1182840124219600794==" MIME-Version: 1.0 Subject: BUG #18568: BUG: Result wrong when do group by on partition table! To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: 1105066510@qq.com Reply-To: 1105066510@qq.com, pgsql-bugs@lists.postgresql.org Date: Tue, 06 Aug 2024 06:23:43 +0000 Message-ID: <18568-2a9afb6b9f7e6ed3@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 --===============1182840124219600794== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODU2OApMb2dnZWQgYnk6ICAgICAgICAgIFdlYmJvIEhhbgpFbWFpbCBh ZGRyZXNzOiAgICAgIDExMDUwNjY1MTBAcXEuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTYuMwpP cGVyYXRpbmcgc3lzdGVtOiAgIGNlbnRvcyA3LjYKRGVzY3JpcHRpb246ICAgICAgICAKCkZpcnN0 LCB3ZSBjcmVhdGUgb25lIGNhc2UtaW5zZW5zaXRpdmUgY29sbGF0aW9uIHVzZSBJQ1U6DQpgYGBz cWwNCglDUkVBVEUgQ09MTEFUSU9OIGNhc2VfaW5zZW5zaXRpdmUgKA0KCQlwcm92aWRlciA9IGlj dSwNCgkJbG9jYWxlID0gJ3VuZC11LWtzLWxldmVsMicsDQoJCWRldGVybWluaXN0aWMgPSBmYWxz ZQ0KCSk7DQpgYGANCg0KVGhlbiwgd2UgY3JlYXRlIHRoZSBwYXJ0aXRpb24gdGFibGUsIG1lYW53 aGlsZSB3ZSBzZXQgdGhlIGNvbGxhdGlvbiBvZgpjb2x1bW4gYyB0byBgY2FzZV9pbnNlbnNpdGl2 ZWAsDQphbmQgc2V0IHBhcnRrZXkncyBjb2xsYXRpb24gdG8gJ0MnLg0KYGBgc3FsDQoJU0VUIGVu YWJsZV9wYXJ0aXRpb253aXNlX2FnZ3JlZ2F0ZSBUTyB0cnVlOw0KCVNFVCBlbmFibGVfcGFydGl0 aW9ud2lzZV9qb2luIFRPIHRydWU7DQoJU0VUIG1heF9wYXJhbGxlbF93b3JrZXJzX3Blcl9nYXRo ZXIgVE8gMDsNCglTRVQgZW5hYmxlX2luY3JlbWVudGFsX3NvcnQgVE8gb2ZmOw0KCUNSRUFURSBU QUJMRSBwYWdnX3RhYiAoYyB0ZXh0IGNvbGxhdGUgY2FzZV9pbnNlbnNpdGl2ZSkgUEFSVElUSU9O IEJZIExJU1QoYwpjb2xsYXRlICJDIik7DQoJQ1JFQVRFIFRBQkxFIHBhZ2dfdGFiX3AxIFBBUlRJ VElPTiBPRiBwYWdnX3RhYiBGT1IgVkFMVUVTIElOICgnYScsICdiJywKJ2MnLCAnZCcpOw0KCUNS RUFURSBUQUJMRSBwYWdnX3RhYl9wMiBQQVJUSVRJT04gT0YgcGFnZ190YWIgRk9SIFZBTFVFUyBJ TiAoJ2UnLCAnZicsCidBJyk7DQoJQ1JFQVRFIFRBQkxFIHBhZ2dfdGFiX3AzIFBBUlRJVElPTiBP RiBwYWdnX3RhYiBGT1IgVkFMVUVTIElOICgnQicsICdDJywKJ0QnLCAnRScpOw0KCUlOU0VSVCBJ TlRPIHBhZ2dfdGFiIFNFTEVDVCBzdWJzdHIoJ2FiY2RlQUJDREUnLCAoaSAlIDEwKSArMSAsIDEp IEZST00KZ2VuZXJhdGVfc2VyaWVzKDAsIDI5OTkpIGk7DQoJQU5BTFlaRSBwYWdnX3RhYjsNCmBg YA0KDQpXZSBkbyBncm91cCBieSBvbiB0aGUgdGFibGUgcGFnZ190YWIgdXNlIGBjYXNlX2luc2Vu c2l0aXZlYCBjb2xsYXRpb24sIHdlCmhvcGUgZ3JvdXAga2V5IGlzIGNhc2UtaW5zZW5zaXRpdmUu DQpidXQgd2UgZmluZCB0aGUgZXhlY3V0aW9uIHJlc3VsdCBpcyBub3Qgd2hhdCB3ZSBleHBlY3Rl ZC4NCmBgYHNoZWxsDQoJcG9zdGdyZXM9IyBTRUxFQ1QgYyBjb2xsYXRlIGNhc2VfaW5zZW5zaXRp dmUsIGNvdW50KGMpIEZST00gcGFnZ190YWIgR1JPVVAKQlkgYyBjb2xsYXRlIGNhc2VfaW5zZW5z aXRpdmU7DQoJIGMgfCBjb3VudA0KCS0tLSstLS0tLS0tDQoJIEEgfCAgIDMwMA0KCSBlIHwgICAz MDANCgkgRSB8ICAgMzAwDQoJIEQgfCAgIDMwMA0KCSBDIHwgICAzMDANCgkgQiB8ICAgMzAwDQoJ IGQgfCAgIDMwMA0KCSBjIHwgICAzMDANCgkgYiB8ICAgMzAwDQoJIGEgfCAgIDMwMA0KCSgxMCBy b3dzKQ0KYGBgDQoNClRoZSByZWFzb24gaXMgdGhlIGZ1bmN0aW9uIGdyb3VwX2J5X2hhc19wYXJ0 a2V5KCkgZG8gbm90IGNoZWNrIHBhcnRrZXkncwpjb2xsYXRpb24sIHRoYXQgbGVhZCB0byBleHBs YWluIGVycm9yLg0KYGBgc2hlbGwNCglwb3N0Z3Jlcz0jIEVYUExBSU4gU0VMRUNUIGMgY29sbGF0 ZSBjYXNlX2luc2Vuc2l0aXZlLCBjb3VudChjKSBGUk9NCnBhZ2dfdGFiIEdST1VQIEJZIGMgY29s bGF0ZSBjYXNlX2luc2Vuc2l0aXZlIDsNCgkgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIFFVRVJZIFBMQU4NCgktLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KCSBBcHBl bmQgIChjb3N0PTEyLjAwLi42MC4xNSByb3dzPTEwIHdpZHRoPTEwKQ0KCSAgIC0+ICBIYXNoQWdn cmVnYXRlICAoY29zdD0xMi4wMC4uMTIuMDIgcm93cz0yIHdpZHRoPTEwKQ0KCSAgICAgICAgIEdy b3VwIEtleTogcGFnZ190YWIuYw0KCSAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBwYWdnX3RhYl9w MiBwYWdnX3RhYiAgKGNvc3Q9MC4wMC4uOS4wMCByb3dzPTYwMAp3aWR0aD0yKQ0KCSAgIC0+ICBI YXNoQWdncmVnYXRlICAoY29zdD0yNC4wMC4uMjQuMDQgcm93cz00IHdpZHRoPTEwKQ0KCSAgICAg ICAgIEdyb3VwIEtleTogcGFnZ190YWJfMS5jDQoJICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHBh Z2dfdGFiX3AzIHBhZ2dfdGFiXzEgIChjb3N0PTAuMDAuLjE4LjAwCnJvd3M9MTIwMCB3aWR0aD0y KQ0KCSAgIC0+ICBIYXNoQWdncmVnYXRlICAoY29zdD0yNC4wMC4uMjQuMDQgcm93cz00IHdpZHRo PTEwKQ0KCSAgICAgICAgIEdyb3VwIEtleTogcGFnZ190YWJfMi5jDQoJICAgICAgICAgLT4gIFNl cSBTY2FuIG9uIHBhZ2dfdGFiX3AxIHBhZ2dfdGFiXzIgIChjb3N0PTAuMDAuLjE4LjAwCnJvd3M9 MTIwMCB3aWR0aD0yKQ0KCSgxMCByb3dzKQ0KYGBgDQoNClNvLCBncm91cF9ieV9oYXNfcGFydGtl eSgpIG5lZWQgdG8gdmVyaWZ5IGlmIHRoZSBwYXJ0a2V5J3MgY29sbGF0aW9uIG1hdGNoZXMKdGhl IGdyb3Vwa2V5LA0KbWVhbndoaWxlLCBpZiBncm91cGtleSBpcyBSZWxhYmVsVHlwZSBub2RlIGFu ZCBpdCdzIGNvbGxhdGlvbiBlcXVhbCB0bwpwYXJ0a2V5J3MsIGl0IHNob3VsZCANCmFsc28gc2V0 IHZhcmlhYmxlIGBmb3VuZGAgdG8gdHJ1ZS4KCg== --===============1182840124219600794==--