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 1s7Abt-0045T3-Ht for pgsql-bugs@arkaria.postgresql.org; Wed, 15 May 2024 09:07:43 +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 1s7Abt-00CX8C-CH for pgsql-bugs@arkaria.postgresql.org; Wed, 15 May 2024 09:07:41 +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 1s6zUN-003FHD-2m for pgsql-bugs@lists.postgresql.org; Tue, 14 May 2024 21:15:11 +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 1s6zUI-000FcL-Pi for pgsql-bugs@lists.postgresql.org; Tue, 14 May 2024 21:15:10 +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=GqWKmierTlnsZAXpWXxEuseXO1y0r7KTCONmzWYLOQE=; b=hbO+RhxAYHJwhhUIa36KpMggZP 3Xotd1bAObWCt8DRZx6/ckdVN1wxNjGURHSoM18n5o7mBXQZOrp6f0ODNgUp3QlNeOJ2Rt4wmnMgb 9STFcsRr5twZDwiaH9fEd0qqf9kxBIYyIYRNDPC4O6iR5ZgvmfALR4Z9KoxKhIszkZ3NlluGlBqrK C8vrQh0wI23P6SIpi3Nc6O+crEf852wJ6lZLrktZ0oEPfzVPqwae8G1/FN6ryzv34paiAQB1GyfpR pMP6NjFDCqWGAPgxvyGlE/HVrTAOMTJhUUkMQTc8VrS+vFTPmmxQW5CtjcWvKpHmWut0D6VtOS90e 6aCncZGg==; 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 1s6zUH-000fsE-Ri for pgsql-bugs@lists.postgresql.org; Tue, 14 May 2024 21:15:05 +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 1s6zUF-001526-0I for pgsql-bugs@lists.postgresql.org; Tue, 14 May 2024 21:15:03 +0000 Content-Type: multipart/mixed; boundary="===============9023360915371533151==" MIME-Version: 1.0 Subject: BUG #18465: Wrong results from SELECT DISTINCT MIN in scalar subquery using HashAggregate To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mtakahar@gmail.com Reply-To: mtakahar@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 14 May 2024 21:14:34 +0000 Message-ID: <18465-2fae927718976b22@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 --===============9023360915371533151== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODQ2NQpMb2dnZWQgYnk6ICAgICAgICAgIEhhbCBUYWthaGFyYQpFbWFp bCBhZGRyZXNzOiAgICAgIG10YWthaGFyQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE1 LjcKT3BlcmF0aW5nIHN5c3RlbTogICBtYWNPUyAxMy42CkRlc2NyaXB0aW9uOiAgICAgICAgCgoq IFRoZSBxdWVyeSBpbiB0aGUgZXhhbXBsZSBiZWxvdyByZXR1cm5zIHdyb25nIHJlc3VsdHMgd2hl biBIYXNoQWdncmVnYXRlIGlzCnVzZWQgZm9yIGVsaW1pbmF0aW5nIHRoZSBkdXBsaWNhdGVzIGZv ciBESVNUSU5DVC4NCg0KcG9zdGdyZXM9IyBzZWxlY3QgdmVyc2lvbigpOw0KICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB2ZXJzaW9uICAg ICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg DQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0NCiBQb3N0Z3JlU1FMIDE1LjcgKEhvbWVicmV3KSBvbiB4ODZfNjQtYXBw bGUtZGFyd2luMjIuNi4wLCBjb21waWxlZCBieSBBcHBsZQpjbGFuZyB2ZXJzaW9uIDE1LjAuMCAo Y2xhbmctMTUwMC4xLjAuMi41KSwgNjQtYml0DQooMSByb3cpDQoNCnBvc3RncmVzPSMgQ1JFQVRF IFRBQkxFIGIgKGNvbF9pbnQgaW50KTsNCkNSRUFURSBUQUJMRSBjYyAoY29sX2ludCBpbnQpOw0K DQpJTlNFUlQgSU5UTyBiIHZhbHVlcyAoMSk7DQpJTlNFUlQgSU5UTyBjYyB2YWx1ZXMgKG51bGwp LCAoMSksICgyKTsNCg0KQ1JFQVRFIFRBQkxFDQpwb3N0Z3Jlcz0jIENSRUFURSBUQUJMRQ0KcG9z dGdyZXM9IyBwb3N0Z3Jlcz0jIElOU0VSVCAwIDENCnBvc3RncmVzPSMgSU5TRVJUIDAgMw0KcG9z dGdyZXM9IyBwb3N0Z3Jlcz0jIFxwc2V0IG51bGwgJzxudWxsPicNCk51bGwgZGlzcGxheSBpcyAi PG51bGw+Ii4NCnBvc3RncmVzPSMgU0VUIGVuYWJsZV9oYXNoYWdnID0gT047IFNFVCBlbmFibGVf c29ydCA9IE9GRjsNClNFVA0KU0VUDQpwb3N0Z3Jlcz0jIFNFTEVDVCAoICBTRUxFQ1QgIERJU1RJ TkNUICBNSU4oIGNvbF9pbnQgICkgIEZST00gQiAgQVMKU1VCUVVFUlkxX3QxICBXSEVSRSBTVUJR VUVSWTFfdDEgLmNvbF9pbnQgID0gdGFibGUxIC5jb2xfaW50ICApLCB0YWJsZTEKLmNvbF9pbnQg IEZST00gQ0MgIEFTIHRhYmxlMSAgICA7DQogIG1pbiAgIHwgY29sX2ludCANCi0tLS0tLS0tKy0t LS0tLS0tLQ0KIDxudWxsPiB8ICA8bnVsbD4NCiA8bnVsbD4gfCAgICAgICAxICAgICAgICA8LS0t LS0tLSAqKiogd3JvbmcgKioqDQogPG51bGw+IHwgICAgICAgMg0KKDMgcm93cykNCg0KcG9zdGdy ZXM9IyBFWFBMQUlOIFNFTEVDVCAoICBTRUxFQ1QgIERJU1RJTkNUICBNSU4oIGNvbF9pbnQgICkg IEZST00gQiAgQVMKU1VCUVVFUlkxX3QxICBXSEVSRSBTVUJRVUVSWTFfdDEgLmNvbF9pbnQgID0g dGFibGUxIC5jb2xfaW50ICApLCB0YWJsZTEKLmNvbF9pbnQgIEZST00gQ0MgIEFTIHRhYmxlMSAg ICA7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOICAg ICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tDQogU2VxIFNjYW4gb24gY2MgdGFibGUxICAoY29zdD0wLjAwLi44MzA2Ljgy IHJvd3M9MjU1MCB3aWR0aD04KQ0KICAgU3ViUGxhbiAyDQogICAgIC0+ICBIYXNoQWdncmVnYXRl ICAoY29zdD0zLjIzLi4zLjI0IHJvd3M9MSB3aWR0aD00KQ0KICAgICAgICAgICBHcm91cCBLZXk6 ICQxDQogICAgICAgICAgIEluaXRQbGFuIDEgKHJldHVybnMgJDEpDQogICAgICAgICAgICAgLT4g IExpbWl0ICAoY29zdD0wLjAwLi4zLjIyIHJvd3M9MSB3aWR0aD00KQ0KICAgICAgICAgICAgICAg ICAgIC0+ICBTZXEgU2NhbiBvbiBiIHN1YnF1ZXJ5MV90MSAgKGNvc3Q9MC4wMC4uNDEuODggcm93 cz0xMwp3aWR0aD00KQ0KICAgICAgICAgICAgICAgICAgICAgICAgIEZpbHRlcjogKChjb2xfaW50 IElTIE5PVCBOVUxMKSBBTkQgKGNvbF9pbnQgPQp0YWJsZTEuY29sX2ludCkpDQogICAgICAgICAg IC0+ICBSZXN1bHQgIChjb3N0PTMuMjIuLjMuMjMgcm93cz0xIHdpZHRoPTQpDQooOSByb3dzKQ0K DQpwb3N0Z3Jlcz0jIFNFVCBlbmFibGVfaGFzaGFnZyA9IE9GRjsgU0VUIGVuYWJsZV9zb3J0ID0g T047DQpTRVQNClNFVA0KcG9zdGdyZXM9IyBTRUxFQ1QgKCAgU0VMRUNUICBESVNUSU5DVCAgTUlO KCBjb2xfaW50ICApICBGUk9NIEIgIEFTClNVQlFVRVJZMV90MSAgV0hFUkUgU1VCUVVFUlkxX3Qx IC5jb2xfaW50ICA9IHRhYmxlMSAuY29sX2ludCAgKSwgdGFibGUxCi5jb2xfaW50ICBGUk9NIEND ICBBUyB0YWJsZTEgICAgOw0KICBtaW4gICB8IGNvbF9pbnQgDQotLS0tLS0tLSstLS0tLS0tLS0N CiA8bnVsbD4gfCAgPG51bGw+DQogICAgICAxIHwgICAgICAgMSAgICAgICAgPC0tLS0tLS0gKioq IGNvcnJlY3QgKioqDQogPG51bGw+IHwgICAgICAgMg0KKDMgcm93cykNCg0KcG9zdGdyZXM9IyBF WFBMQUlOIFNFTEVDVCAoICBTRUxFQ1QgIERJU1RJTkNUICBNSU4oIGNvbF9pbnQgICkgIEZST00g QiAgQVMKU1VCUVVFUlkxX3QxICBXSEVSRSBTVUJRVUVSWTFfdDEgLmNvbF9pbnQgID0gdGFibGUx IC5jb2xfaW50ICApLCB0YWJsZTEKLmNvbF9pbnQgIEZST00gQ0MgIEFTIHRhYmxlMSAgICA7DQog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOICAgICAgICAg ICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tDQogU2VxIFNjYW4gb24gY2MgdGFibGUxICAoY29zdD0wLjAwLi44MzE5LjU3IHJvd3M9 MjU1MCB3aWR0aD04KQ0KICAgU3ViUGxhbiAyDQogICAgIC0+ICBVbmlxdWUgIChjb3N0PTMuMjQu LjMuMjUgcm93cz0xIHdpZHRoPTQpDQogICAgICAgICAgIEluaXRQbGFuIDEgKHJldHVybnMgJDEp DQogICAgICAgICAgICAgLT4gIExpbWl0ICAoY29zdD0wLjAwLi4zLjIyIHJvd3M9MSB3aWR0aD00 KQ0KICAgICAgICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBiIHN1YnF1ZXJ5MV90MSAgKGNv c3Q9MC4wMC4uNDEuODggcm93cz0xMwp3aWR0aD00KQ0KICAgICAgICAgICAgICAgICAgICAgICAg IEZpbHRlcjogKChjb2xfaW50IElTIE5PVCBOVUxMKSBBTkQgKGNvbF9pbnQgPQp0YWJsZTEuY29s X2ludCkpDQogICAgICAgICAgIC0+ICBTb3J0ICAoY29zdD0zLjI0Li4zLjI1IHJvd3M9MSB3aWR0 aD00KQ0KICAgICAgICAgICAgICAgICBTb3J0IEtleTogKCQxKQ0KICAgICAgICAgICAgICAgICAt PiAgUmVzdWx0ICAoY29zdD0zLjIyLi4zLjIzIHJvd3M9MSB3aWR0aD00KQ0KKDEwIHJvd3MpDQoN Cg0KKiBUaGUgc3VicXVlcnkgaXMgcmV0dXJuaW5nIHRoZSBmaXJzdCByZXN1bHQgZm9yIGFsbCB0 aGUgc3Vic2VxdWVudAp0dXBsZXM6DQoNCnBvc3RncmVzPSMgU0VUIGVuYWJsZV9oYXNoYWdnID0g T047IFNFVCBlbmFibGVfc29ydCA9IE9GRjsNClNFVA0KU0VUDQpwb3N0Z3Jlcz0jIFRSVU5DQVRF IFRBQkxFIGNjOw0KVFJVTkNBVEUgVEFCTEUNCnBvc3RncmVzPSMgSU5TRVJUIElOVE8gY2MgdmFs dWVzICgxKSwgKDIpLCAobnVsbCk7DQpJTlNFUlQgMCAzDQpwb3N0Z3Jlcz0jIFNFVCBlbmFibGVf aGFzaGFnZyA9IE9OOyBTRVQgZW5hYmxlX3NvcnQgPSBPRkY7DQpTRVQNClNFVA0KcG9zdGdyZXM9 IyBTRUxFQ1QgKCAgU0VMRUNUICBESVNUSU5DVCAgTUlOKCBjb2xfaW50ICApICBGUk9NIEIgIEFT ClNVQlFVRVJZMV90MSAgV0hFUkUgU1VCUVVFUlkxX3QxIC5jb2xfaW50ICA9IHRhYmxlMSAuY29s X2ludCAgKSwgdGFibGUxCi5jb2xfaW50ICBGUk9NIENDICBBUyB0YWJsZTEgICAgOw0KIG1pbiB8 IGNvbF9pbnQgDQotLS0tLSstLS0tLS0tLS0NCiAgIDEgfCAgICAgICAxICAgICAgICA8LS0tLS0t LSAqKiogY29ycmVjdCAqKioNCiAgIDEgfCAgICAgICAyICAgICAgICA8LS0tLS0tLSAqKiogd3Jv bmcgKioqDQogICAxIHwgIDxudWxsPiAgICAgICAgPC0tLS0tLS0gKioqIHdyb25nICoqKg0KKDMg cm93cykKCg== --===============9023360915371533151==--