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 1qjHt1-00A8po-Ve for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Sep 2023 11:30: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 1qjHt0-00BW9d-Hm for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Sep 2023 11:30:22 +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 1qjHNp-00BFQR-Ti for pgsql-bugs@lists.postgresql.org; Thu, 21 Sep 2023 10:58:10 +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.94.2) (envelope-from ) id 1qjHNm-005nU7-My for pgsql-bugs@lists.postgresql.org; Thu, 21 Sep 2023 10:58:08 +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=zDvsWTdnlh4QNgHQuoMlmFru6W/JUQthEQzPy0i4FpA=; b=6sBYB6J6d2inOFq2joPo9veYuG 7xZBcL34Ol59jcVybhSaZ9WiIxtng5ObMFrmJnBRORes7tV2Y05IBtnFeJ9DLM+kNRgenqN+p8Q1F GNIioWM4p6VN6a9DxedrIP4f7E/SWzjsQQXNF0OidtKMdGXMlKGfBqL4vQ459quXv4NJKwr7jg/2n JhqRGzXpfXaEQdGyyd3KdN93el0P+BgGzCnxZWJaOA2B+hNplIO0b+kwi6zpUY3aIksRxoOkuW9BX Rp7s8TjjXylPwUcjqgqtpQZd8xewpwq1rTY3gc8UInYlMNWtlOgaIsjYeG3fZvfUjBy6s3xXfa3OJ AqpEaPnQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qjHNl-0002GB-75 for pgsql-bugs@lists.postgresql.org; Thu, 21 Sep 2023 10:58: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 1qjHNi-001rbH-6X for pgsql-bugs@lists.postgresql.org; Thu, 21 Sep 2023 10:58:02 +0000 Content-Type: multipart/mixed; boundary="===============5692760624617300781==" MIME-Version: 1.0 Subject: BUG #18126: Ordered set aggregate: result does not depend on sort order To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: wollhofen@unisoftwareplus.com Reply-To: wollhofen@unisoftwareplus.com, pgsql-bugs@lists.postgresql.org Date: Thu, 21 Sep 2023 10:57:26 +0000 Message-ID: <18126-b4b5de7206c972e3@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 --===============5692760624617300781== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODEyNgpMb2dnZWQgYnk6ICAgICAgICAgIFJpY2hhcmQgV29sbGhvZmVu CkVtYWlsIGFkZHJlc3M6ICAgICAgd29sbGhvZmVuQHVuaXNvZnR3YXJlcGx1cy5jb20KUG9zdGdy ZVNRTCB2ZXJzaW9uOiAxNi4wCk9wZXJhdGluZyBzeXN0ZW06ICAgRGViaWFuIDE2LjAtMS5wZ2Rn MTIwKzEKRGVzY3JpcHRpb246ICAgICAgICAKClByb2JhYmx5IHJlbGF0ZWQgdG8gYnVnIHJlcG9y dCAjMTgxMjUuDQpVc2luZyBhIGN1c3RvbSBvcmRlcmVkIHNldCBhZ2dyZWdhdGUsIHRoZSBzb3J0 IG9yZGVyIGluIHRoZSBPUkRFUiBCWSBhZnRlcgp0aGUgV0lUSElOIEdST1VQIGRvZXMgbm90IHNo b3cgYW4gaW5mbHVlbmNlIG9uIHRoZSByZXN1bHRzLCBhcyBkZW1vbnN0cmF0ZWQKaW4gdGhlIHNj cmlwdCBiZWxvdy4gVGhlcmUgYXJlIHRocmVlIHBvc3NpYmxlIHdheXMgdG8gYWNoaWV2ZSB0aGUg c2FtZQphc2NlbmRpbmcgb3IgZGVzY2VuZGluZyBzb3J0IG9yZGVyIGluIHRoZSB0ZXN0IGRhdGEs IHJlc3BlY3RpdmVseS4gSG93ZXZlciwKdGhlIHJlc3VsdCBkZXBlbmRzIG9uIFdIQVQgaXMgdXNl ZCBmb3Igc29ydGluZyAoY29sdW1ucywgd2hvbGUgcm93KSBpbnN0ZWFkCm9mIHRoZSBhY3R1YWwg b3JkZXJlZCByZXN1bHQgc2V0Lg0KVGVzdGVkIGZvciBwb3N0Z3JlcyBtYWpvciB2ZXJzaW9ucyAx MCAtIDE2Lg0KDQoNCkxpbmsgdG8gdGVzdCBzY3JpcHQNCmh0dHBzOi8vZGJmaWRkbGUudWsvMkc3 TmdYUG4NCg0KDQotLSBjdXN0b20gbWQ1IGFnZ3JlZ2F0ZSBzZnVuYw0KQ1JFQVRFIEZVTkNUSU9O IG1kNV9hZ2dfc2Z1bmModGV4dCwgYW55ZWxlbWVudCkNCiAgICAgICBSRVRVUk5TIHRleHQNCiAg ICAgICBMQU5HVUFHRSBzcWwNCkFTDQokJA0KICBTRUxFQ1QgbWQ1KCQxIHx8ICQyOjp0ZXh0KQ0K JCQ7DQoNCi0tIGN1c3RvbSBtZDUgYWdncmVnYXRlIGZ1bmN0aW9uDQpDUkVBVEUgQUdHUkVHQVRF IG1kNV9hZ2cgKE9SREVSIEJZIGFueWVsZW1lbnQpDQooDQogIFNUWVBFID0gdGV4dCwNCiAgU0ZV TkMgPSBtZDVfYWdnX3NmdW5jLA0KICBJTklUQ09ORCA9ICcnDQopOw0KDQotLSB0ZXN0IGRhdGEs IHR3byBjb3JyZWxhdGVkIGNvbHVtbnMNCkNSRUFURSBUQUJMRSB0X3Rlc3QgKGEgaW50LCBiIGlu dCk7DQpJTlNFUlQgSU5UTyB0X3Rlc3QNCiAgICAgICBTRUxFQ1QgICB4LCB4ICsgMTANCiAgICAg ICBGUk9NICAgICBnZW5lcmF0ZV9zZXJpZXMoMSwgMTAwMDAwKSBBUyB4Ow0KDQotLSBSZXN1bHQg Zm9yIEFTQyBzb3J0IG9yZGVyIGlzIHRoZSBzYW1lIGZvciBhbGwgdGhyZWUgY3JpdGVyaWEhDQpT RUxFQ1QgKiBGUk9NIHRfdGVzdCBPUkRFUiBCWSB0X3Rlc3QgQVNDIExJTUlUIDM7DQpTRUxFQ1Qg KiBGUk9NIHRfdGVzdCBPUkRFUiBCWSB0X3Rlc3QuYSBBU0MgTElNSVQgMzsNClNFTEVDVCAqIEZS T00gdF90ZXN0IE9SREVSIEJZIHRfdGVzdC5iIEFTQyBMSU1JVCAzOw0KDQotLSBSZXN1bHQgZm9y IERFU0Mgc29ydCBvcmRlciBpcyB0aGUgc2FtZSBmb3IgYWxsIHRocmVlIGNyaXRlcmlhIQ0KU0VM RUNUICogRlJPTSB0X3Rlc3QgT1JERVIgQlkgdF90ZXN0IERFU0MgTElNSVQgMzsNClNFTEVDVCAq IEZST00gdF90ZXN0IE9SREVSIEJZIHRfdGVzdC5hIERFU0MgTElNSVQgMzsNClNFTEVDVCAqIEZS T00gdF90ZXN0IE9SREVSIEJZIHRfdGVzdC5iIERFU0MgTElNSVQgMzsNCg0KLS0gZXhwZWN0ZWQg MiBoYXNoZXMsIGhhc2ggSDEgZm9yIGNvbHVtbnMgMS0zIGZvciBBU0Mgb3JkZXIsIA0KLS0gICAg ICAgICAgICAgICAgICAgIGhhc2ggSDIgZm9yIGNvbHVtbnMgNC02IGZvciBERVNDIG9yZGVyDQpT RUxFQ1QgbWQ1X2FnZygpIFdJVEhJTiBHUk9VUCAoT1JERVIgQlkgdF90ZXN0IEFTQyksDQogICAg ICAgbWQ1X2FnZygpIFdJVEhJTiBHUk9VUCAoT1JERVIgQlkgdF90ZXN0LmEgQVNDKSwNCiAgICAg ICBtZDVfYWdnKCkgV0lUSElOIEdST1VQIChPUkRFUiBCWSB0X3Rlc3QuYiBBU0MpLA0KICAgICAg IG1kNV9hZ2coKSBXSVRISU4gR1JPVVAgKE9SREVSIEJZIHRfdGVzdCBERVNDKSwNCiAgICAgICBt ZDVfYWdnKCkgV0lUSElOIEdST1VQIChPUkRFUiBCWSB0X3Rlc3QuYSBERVNDKSwNCiAgICAgICBt ZDVfYWdnKCkgV0lUSElOIEdST1VQIChPUkRFUiBCWSB0X3Rlc3QuYiBERVNDKQ0KRlJPTSB0X3Rl c3Q7DQotLSByZWNlaXZlZCAzIGhhc2hlczoNCi0tICAgICAgICAgICAgICAgSDMgZm9yIGNvbC4g MSwgNA0KLS0gICAgICAgICAgICAgICBINCBmb3IgY29sLiAyLCA1DQotLSAgICAgICAgICAgICAg IEg1IGZvciBjb2wuIDMsIDYNCi0tIFNvcnQgb3JkZXIgaGFzIG5vIGluZmx1ZW5jZS4gDQotLSBT cGVjaWZpY2F0aW9uIG9mIG9yZGVyIGNyaXRlcmlvbiAod2hvbGUgcmVjb3JkIG9yIGRpZmZlcmVu dCBjb2x1bW5zKQpkZXRlcm1pbmVzIHRoZSByZXN1bHQuCgo= --===============5692760624617300781==--