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 1rLueN-001LLh-Rz for pgsql-bugs@arkaria.postgresql.org; Sat, 06 Jan 2024 00:34: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 1rLueM-005g2x-8u for pgsql-bugs@arkaria.postgresql.org; Sat, 06 Jan 2024 00:34:54 +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 1rLs16-004dix-Bk for pgsql-bugs@lists.postgresql.org; Fri, 05 Jan 2024 21:46: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 1rLs0z-0003Yx-Bi for pgsql-bugs@lists.postgresql.org; Fri, 05 Jan 2024 21:46: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=agayapdYvfVxERpm7W/tHy7haXQMlLtR0DKCGCSB2cY=; b=Fw0d60HNv5khXreWm7NhSNt5sP ahjLrHlqxvfeZq6uX1CABVXLQ8qG7ALV4cm2Ciun2hgvz+yXcUGIDAnaO6/tzuwu9lT5oMDZiiVSB IxeVLKdfUvBGbfMFHGSL1dORA7U6SbZQzp6OWT14KkmErjsPhH2S0c57Q8nw8MUnKcHk7AeRFuY0P XtZqUyx3w8CMR1ULQhqkXBmwuNDJfs4cFHLhhBMqxmClX8tpauYvKnIlSf5L+Oe5sXp6gL06rfC58 n9vs8P9TGC7r65sZ2iB0FdkeXR6JPhqjNwYlVSw2xedrVZteYDeWHE59yF/bx1TpAg4CDRNyHBh9q TRiuqrhQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rLs0w-000Cze-RE for pgsql-bugs@lists.postgresql.org; Fri, 05 Jan 2024 21:46:03 +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 1rLs0v-000XWP-Rn for pgsql-bugs@lists.postgresql.org; Fri, 05 Jan 2024 21:46:02 +0000 Content-Type: multipart/mixed; boundary="===============5877526123799675200==" MIME-Version: 1.0 Subject: BUG #18272: ERROR XX000 when selecting string_agg with distinct and subquery - occur in pg16.1 and not in pg15.4 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: enricotrinanes@gmail.com Reply-To: enricotrinanes@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 05 Jan 2024 21:45:28 +0000 Message-ID: <18272-566ab0edabb9cd13@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 --===============5877526123799675200== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODI3MgpMb2dnZWQgYnk6ICAgICAgICAgIEVucmljbyBUcmluYW5lcwpF bWFpbCBhZGRyZXNzOiAgICAgIGVucmljb3RyaW5hbmVzQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZl cnNpb246IDE2LjEKT3BlcmF0aW5nIHN5c3RlbTogICBhYXJjaDY0LXVua25vd24tbGludXgtZ251 IFJlZCBIYXQgNy4zLjEtNiAtIDY0LWJpdApEZXNjcmlwdGlvbjogICAgICAgIAoKLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQotLSBUQUJMRVMg QU5EIFNDRU5BUklPTiBDUkVBVElPTg0KDQotLURST1AgVEFCTEUgZXJyb3JfdGVzdF91c2VyczsN Ci0tRFJPUCBUQUJMRSBlcnJvcl90ZXN0X3JvbGVzOw0KLS1EUk9QIFRBQkxFIGVycm9yX3Rlc3Rf cm9sZV91c2VyOw0KDQotLSBDUkVBVEUgVEFCTEUgVVNFRCBBUyBGUk9NIElOIFRIRSBFUlJPUiBT RUxFQ1QNCkNSRUFURSBUQUJMRSBlcnJvcl90ZXN0X3VzZXJzICgNCiAgICBpZCBpbnQsDQogICAg bmFtZSB2YXJjaGFyKDI1NSksDQogICAgZW1haWwgdmFyY2hhcig1MDApDQopOw0KSU5TRVJUIElO VE8gcHVibGljLmVycm9yX3Rlc3RfdXNlcnMoaWQsIG5hbWUsIGVtYWlsKQ0KCVZBTFVFUyANCgkJ KDEsICdKb2huJywgJ2pvaG5AZXhhbXBsZS5jb20nKSwNCgkJKDIsICdNYXJ5JywgJ2pvaG5AZXhh bXBsZS5jb20nKSwNCgkJKDMsICdBZGFtJywgJ2FkYW1AZXhhbXBsZS5jb20nKSwNCgkJKDQsICdF dmUnLCAnZXZlQGV4YW1wbGUuY29tJykNCjsNCg0KLS0gQ1JFQVRFIFRBQkxFIFVTRUQgQVMgU1RS SUdfQUdHIEFDQ0VTUw0KQ1JFQVRFIFRBQkxFIGVycm9yX3Rlc3Rfcm9sZXMgKA0KICAgIGlkIGlu dCwNCiAgICBuYW1lIHZhcmNoYXIoMjU1KQ0KKTsNCklOU0VSVCBJTlRPIHB1YmxpYy5lcnJvcl90 ZXN0X3JvbGVzKGlkLCBuYW1lKQ0KCVZBTFVFUyANCgkJKDEsICdBbmFsaXN0JyksDQoJCSgyLCAn TWFuYWdlcicpLA0KCQkoMywgJ0RpcmVjdG9yJyksDQoJCSg0LCAnQWRtaW5pc3RyYXRvcicpDQo7 DQoNCi0tIENSRUFURSBUQUJMRSBUSEFUIFdPVUxEIEJFIFVTRUQgQVMgUElWT1QgRk9SIEpPSU5J TkcgVEhFIEFHRyBUQUJMRSBBTkQKU0VQQVJBVEUgSVQgV0lUSA0KLS0gcmVsYXRpb25fdHlwZSBT TyBXRSBDQU4gSEFWRSBNVUxUSVBMRSBDT0xVTU5TIFRSWUlORyBUTyBHRVQgRElGRkVSRU5UCkdS T1VQUw0KQ1JFQVRFIFRBQkxFIGVycm9yX3Rlc3Rfcm9sZV91c2VyICgNCiAgICB1c2VyX2lkIGlu dCwNCiAgICByb2xlX2lkIGludCwNCiAgICByZWxhdGlvbl90eXBlIHNtYWxsaW50DQopOw0KSU5T RVJUIElOVE8gcHVibGljLmVycm9yX3Rlc3Rfcm9sZV91c2VyKHVzZXJfaWQsIHJvbGVfaWQsIHJl bGF0aW9uX3R5cGUpDQoJVkFMVUVTIA0KCQkoMSwgMSwgMSksICgxLCAyLCAyKSwgKDEsIDMsIDEp LA0KCQkoMiwgMSwgMiksICgyLCAzLCAyKSwNCgkJKDMsIDEsIDEpLCAoMywgMiwgMSksICgzLCAz LCAyKSwgKDMsIDQsIDIpLA0KCQkoNCwgNCwgMSkNCjsNCg0KLS0gQ0hFQ0sgQ1JFQVRJT04NCnNl bGVjdCAqIGZyb20gZXJyb3JfdGVzdF91c2VyczsNCnNlbGVjdCAqIGZyb20gZXJyb3JfdGVzdF9y b2xlczsNCnNlbGVjdCAqIGZyb20gZXJyb3JfdGVzdF9yb2xlX3VzZXI7DQoNCg0KLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQotLSBTRUxFQ1Qg VEhBVCBHSVZFUyBFUlJPUi4gUkVMQVRFRCBUTyBTVFJJTkdfQUdHKERJU1RJTkNUIChTRUxFQ1Qp KQ0KLS0gdGhpcyBraW5kIG9mIHNlbGVjdCBjYW4gYmUgZG9uZSBieSBvdGhlciBtZWFucywgYnV0 IGluIHRoaXMgY2FzZSwNCi0tIGkgYW0gdXNpbmcgaXQgb25seSBhcyBhIHNpbXBsaWZpZWQgdmVy c2lvbiB0aGF0IGdpdmVzIHRoZSBzYW1lDQotLSBlcnJvciBvZiB3aGF0IHdhcyBteSBzY2VuYXJp bywgc28geW91IGNhbiBhbmFseXNlIGl0IHdpdGhvdXQgbWFueQp1bmVjZXNzYXJ5IGpvaW5zDQpz ZWxlY3QNCgllcnJvcl90ZXN0X3VzZXJzLmlkLA0KCWVycm9yX3Rlc3RfdXNlcnMubmFtZSwNCgll cnJvcl90ZXN0X3VzZXJzLmVtYWlsLA0KCU1BWChyZWxhdGlvbl90eXBlXzEucm9sZV9pZCkgYXMg bWF4X2lkX3JlbGF0aW9uX3R5cGVfMSwNCglNQVgocmVsYXRpb25fdHlwZV8yLnJvbGVfaWQpIGFz IG1heF9pZF9yZWxhdGlvbl90eXBlXzIsDQoJc3RyaW5nX2FnZyhkaXN0aW5jdA0KCQkoc2VsZWN0 IG5hbWUgZnJvbSBlcnJvcl90ZXN0X3JvbGVzIHdoZXJlIGVycm9yX3Rlc3Rfcm9sZXMuaWQgPQpy ZWxhdGlvbl90eXBlXzEucm9sZV9pZCkNCgksICcsICcpIGFzIHJvbGVzX3JlbGF0aW9uX3R5cGVf MSwNCglzdHJpbmdfYWdnKGRpc3RpbmN0DQoJCShzZWxlY3QgbmFtZSBmcm9tIGVycm9yX3Rlc3Rf cm9sZXMgd2hlcmUgZXJyb3JfdGVzdF9yb2xlcy5pZCA9CnJlbGF0aW9uX3R5cGVfMi5yb2xlX2lk KQ0KCSwgJywgJykgYXMgcm9sZXNfcmVsYXRpb25fdHlwZV8yDQpmcm9tIGVycm9yX3Rlc3RfdXNl cnMNCmxlZnQgam9pbiBlcnJvcl90ZXN0X3JvbGVfdXNlciBhcyByZWxhdGlvbl90eXBlXzEgb24g cmVsYXRpb25fdHlwZV8xLnVzZXJfaWQKPSBlcnJvcl90ZXN0X3VzZXJzLmlkDQoJYW5kIHJlbGF0 aW9uX3R5cGVfMS5yZWxhdGlvbl90eXBlID0gMQ0KbGVmdCBqb2luIGVycm9yX3Rlc3Rfcm9sZV91 c2VyIGFzIHJlbGF0aW9uX3R5cGVfMiBvbiByZWxhdGlvbl90eXBlXzIudXNlcl9pZAo9IGVycm9y X3Rlc3RfdXNlcnMuaWQNCglhbmQgcmVsYXRpb25fdHlwZV8yLnJlbGF0aW9uX3R5cGUgPSAyDQpn cm91cCBieSAxLDIsMw0KDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0NCi0tIFNFTEVDVCBSRVNVTFRTIElOIERJRkZFUkVOVCBFTlZJUk9OTUVO VFMNCg0KLS0gUG9zdGdyZVNRTCAxNi4xIG9uIGFhcmNoNjQtdW5rbm93bi1saW51eC1nbnUsIGNv bXBpbGVkIGJ5IGdjYyAoR0NDKSA3LjMuMQoyMDE4MDcxMiAoUmVkIEhhdCA3LjMuMS02KSwgNjQt Yml0DQotLSBSRVRVUk4NCi0tIEVSUk9SOiAgYXR0cmlidXRlIG51bWJlciA1IGV4Y2VlZHMgbnVt YmVyIG9mIGNvbHVtbnMgMg0KLS0gRXN0YWRvIFNRTDpYWDAwMA0KDQoNCi0tIFBvc3RncmVTUUwg MTUuNCBvbiBhYXJjaDY0LXVua25vd24tbGludXgtZ251LCBjb21waWxlZCBieSBnY2MgKEdDQykg Ny4zLjEKMjAxODA3MTIgKFJlZCBIYXQgNy4zLjEtNiksIDY0LWJpdA0KLS0gUkVUVVJODQotLQoi aWQiCSJuYW1lIgkiZW1haWwiCQkJCSJtYXhfaWRfcmVsYXRpb25fdHlwZV8xIgkibWF4X2lkX3Jl bGF0aW9uX3R5cGVfMiIJInJvbGVzX3JlbGF0aW9uX3R5cGVfMSIJInJvbGVzX3JlbGF0aW9uX3R5 cGVfMiINCi0tIDEJIkpvaG4iCSJqb2huQGV4YW1wbGUuY29tIgkzCQkJCQkJCTIJCQkJCQkJIkFu YWxpc3QsCkRpcmVjdG9yIgkJIk1hbmFnZXIiDQotLSAyCSJNYXJ5Igkiam9obkBleGFtcGxlLmNv bSIJCQkJCQkJCTMJCQkJCQkJCQkJCQkJIkFuYWxpc3QsIERpcmVjdG9yIg0KLS0gMwkiQWRhbSIJ ImFkYW1AZXhhbXBsZS5jb20iCTIJCQkJCQkJNAkJCQkJCQkiQW5hbGlzdCwKTWFuYWdlciIJCSJB ZG1pbmlzdHJhdG9yLCBEaXJlY3RvciINCi0tIDQJIkV2ZSIJImV2ZUBleGFtcGxlLmNvbSIJNAkJ CQkJCQkJCQkJCQkJIkFkbWluaXN0cmF0b3IiCgo= --===============5877526123799675200==--