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 1u6RfA-00FsWJ-LW for pgsql-committers@arkaria.postgresql.org; Sun, 20 Apr 2025 10:12:37 +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 1u6Rf7-009w5i-CL for pgsql-committers@arkaria.postgresql.org; Sun, 20 Apr 2025 10:12:34 +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 1u6Rf7-009w5a-3u for pgsql-committers@lists.postgresql.org; Sun, 20 Apr 2025 10:12:33 +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.96) (envelope-from ) id 1u6Rf3-0012yP-0K for pgsql-committers@lists.postgresql.org; Sun, 20 Apr 2025 10:12:33 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=nsTjlV0aGBjcaN06PCMpOR/kAR4xWlOZCo4HH6dZ/RY=; b=PWCb3c58inUQD5Onv3Ro7Z9bfD 6VUrudD3YqMzaNw5ymmqDaCB46D8A3wibOCwiIjiMvHTNT4iZVLA5Jk0U39JqHHuo/q/mkb6PBDVY 5cdhqh7xWqfQzqPD3d5Whvg6spwmgBxlbyPidgsgO1GNSlM5X+bar/x49iIJWGp1rxolIDHsygcOf S9g2v0C8ET9ip1yqeOArs74AauPCL4mRR2c2PfMFX11kCgK2pckw62BmIGEalffn7/ZCpV8c7uCDu 03VmJ0MM7sgbct0JV5m8JnZlVdSUWMoSq7TZYnpThL/ymbrQqrAyzvSJqc/4B/SOLopyWUULZhaOt f9KP09vA==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u6Rf1-002qdX-IZ for pgsql-committers@lists.postgresql.org; Sun, 20 Apr 2025 10:12:28 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1u6Rf1-000w7o-1v for pgsql-committers@lists.postgresql.org; Sun, 20 Apr 2025 10:12:27 +0000 Content-Type: multipart/mixed; boundary="===============0157500785201969141==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix issue with ORDER BY / DISTINCT aggregates and FILTER X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 20 Apr 2025 10:12:27 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0157500785201969141== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGlzc3VlIHdpdGggT1JERVIgQlkgLyBESVNUSU5DVCBhZ2dyZWdhdGVzIGFuZCBGSUxURVIK CjEzNDlkMjc5MCBhZGRlZCBzdXBwb3J0IHNvIHRoYXQgYWdncmVnYXRlIGZ1bmN0aW9ucyB3aXRo IGFuIE9SREVSIEJZIG9yCkRJU1RJTkNUIGNsYXVzZSBjb3VsZCBtYWtlIHVzZSBvZiBwcmVzb3J0 ZWQgaW5wdXRzIHRvIGF2b2lkIGFuIGltcGxpY2l0CnNvcnQgd2l0aGluIG5vZGVBZ2cuYy4gIFRo YXQgY29tbWl0IGZhaWxlZCB0byBjb25zaWRlciB0aGF0IGEgRklMVEVSCmNsYXVzZSBtYXkgZXhp c3QgdGhhdCBmaWx0ZXJzIHJvd3MgYmVmb3JlIHRoZSBhZ2dyZWdhdGUgZnVuY3Rpb24KYXJndW1l bnRzIGFyZSBldmFsdWF0ZWQuICBUaGF0IGNhbiBiZSBwcm9ibGVtYXRpYyBpZiBhbiBhZ2dyZWdh dGUKYXJndW1lbnQgY29udGFpbnMgYW4gZXhwcmVzc2lvbiB3aGljaCBjb3VsZCBlcnJvciBvdXQg ZHVyaW5nIGV2YWx1YXRpb24uCkl0J3MgcGVyZmVjdGx5IHZhbGlkIHRvIHdhbnQgdG8gaGF2ZSBh IEZJTFRFUiBjbGF1c2Ugd2hpY2ggZWxpbWluYXRlcwpzdWNoIHZhbHVlcywgYW5kIHdpdGggdGhl IHByZS1zb3J0ZWQgcGF0aCBhZGRlZCBpbiAxMzQ5ZDI3OTAsIGl0IHdhcwpwb3NzaWJsZSB0aGF0 IHRoZSBwbGFubmVyIHdvdWxkIHByb2R1Y2UgYSBwbGFuIHdpdGggYSBTb3J0IG5vZGUgYWJvdmUK dGhlIEFnZ3JlZ2F0ZSB0byBwZXJmb3JtIHRoZSBzb3J0IG9uIHRoZSBhZ2dyZWdhdGUncyBhcmd1 bWVudHMgbG9uZyBiZWZvcmUKdGhlIEFnZ3JlZ2F0ZSBub2RlIHdvdWxkIGZpbHRlciBvdXQgdGhl IG5vbi1tYXRjaGluZyB2YWx1ZXMuCgpIZXJlIHdlIGZpeCB0aGlzIGJ5IGluc3BlY3RpbmcgT1JE RVIgQlkgLyBESVNUSU5DVCBhZ2dyZWdhdGUgZnVuY3Rpb25zCndoaWNoIGhhdmUgYSBGSUxURVIg Y2xhdXNlIHRvIHNlZSBpZiB0aGUgYWdncmVnYXRlJ3MgYXJndW1lbnRzIGFyZQphbnl0aGluZyBt b3JlIGNvbXBsZXggdGhhbiBhIFZhciBvciBhIENvbnN0LiAgRXZhbHVhdGluZyB0aGVzZSBpc24n dApnb2luZyB0byBjYXVzZSBhbiBlcnJvci4gIElmIHdlIGZpbmQgYW55IG5vbi1WYXIsIG5vbi1D b25zdCBwYXJhbWV0ZXJzCnRoZW4gdGhlIHBsYW5uZXIgd2lsbCBub3cgb3B0IHRvIHBlcmZvcm0g dGhlIHNvcnQgaW4gdGhlIEFnZ3JlZ2F0ZSBub2RlCmZvciB0aGVzZSBhZ2dyZWdhdGVzLCBpLmUu IGRpc2FibGUgdGhlIHByZXNvcnRlZCBhZ2dyZWdhdGUgb3B0aW1pemF0aW9uLgoKQW4gYWx0ZXJu YXRpdmUgZml4IHdvdWxkIGhhdmUgYmVlbiB0byBjb21wbGV0ZWx5IGRpc2FsbG93IHRoZSBwcmVz b3J0ZWQKb3B0aW1pemF0aW9uIGZvciBBZ2dyZWZzIHdpdGggYW55IEZJTFRFUiBjbGF1c2UsIGJ1 dCB0aGF0IHdhc24ndCBkb25lIGFzCnRoYXQgY291bGQgY2F1c2UgbGFyZ2UgcGVyZm9ybWFuY2Ug cmVncmVzc2lvbnMgZm9yIHF1ZXJpZXMgdGhhdCBzZWUKc2lnbmlmaWNhbnQgZ2FpbnMgZnJvbSAx MzQ5ZDI3OTAgZHVlIHRvIHByZXNvcnRlZCByZXN1bHRzIGNvbWluZyBpbiBmcm9tCmFuIEluZGV4 IFNjYW4uCgpCYWNrcGF0Y2ggdG8gMTYsIHdoZXJlIDEzNDlkMjc5MCB3YXMgaW50cm9kdWNlZAoK QXV0aG9yOiBEYXZpZCBSb3dsZXkgPGRncm93bGV5bWxAZ21haWwuY29tPgpSZXBvcnRlZC1ieTog S2FpbWVoIDxra2FpbWVoQGdtYWlsLmNvbT4KRGlhZ25vc2VkLWJ5OiBUb20gTGFuZSA8dGdsQHNz cy5wZ2gucGEudXM+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FLLSUyQkp6OUol M0RRMDYtTTdjREpvUE5lWWJ6NUVaRHFralFiSm5tUnlReXprYlJHc1lrQSU0MG1haWwuZ21haWwu Y29tCkJhY2twYXRjaC10aHJvdWdoOiAxNgoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMK LS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2Q0N2Y5MjIy NDZiNTRmMDI5MDgxMTk1MWUwYjczYTNkNjExMDQzN2MKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0t LS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3BsYW5uZXIuYyAgICAgfCA1MSArKysr KysrKysrKysrKysrKysrKysrKysrKysrKy0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2Fn Z3JlZ2F0ZXMub3V0IHwgMzcgKysrKysrKysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVz cy9leHBlY3RlZC9zcWxqc29uLm91dCAgICB8IDI0ICsrKysrKystLS0tLS0tLQpzcmMvdGVzdC9y ZWdyZXNzL3NxbC9hZ2dyZWdhdGVzLnNxbCAgICAgIHwgMTkgKysrKysrKysrKysrCjQgZmlsZXMg Y2hhbmdlZCwgMTE1IGluc2VydGlvbnMoKyksIDE2IGRlbGV0aW9ucygtKQoK --===============0157500785201969141==--