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 1u6Rfs-00Fsn8-Qs for pgsql-committers@arkaria.postgresql.org; Sun, 20 Apr 2025 10:13:21 +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 1u6Rfr-009xTG-3M for pgsql-committers@arkaria.postgresql.org; Sun, 20 Apr 2025 10:13:19 +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 1u6Rfq-009xT8-S2 for pgsql-committers@lists.postgresql.org; Sun, 20 Apr 2025 10:13:19 +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 1u6Rfo-0012yu-1P for pgsql-committers@lists.postgresql.org; Sun, 20 Apr 2025 10:13:19 +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=LTbD40EktZUAE4JuDP6Tgm5/UeURr7rWccDwxzX3WeY=; b=d1zVV601yGZr1U7v7QzMKsm6wF MP4OKnMdUUogLkaLQCttzrkCGfe3VlsSVLRdBUoVuj7wtVQrGpUk4+HfuWLOLe+21+M7B/eQTgsd9 v/TlnLW1vcWbFtWmiix3MMMjzIxLbGRi0+2wxt5BmCC3nSYCG/Mh9DMBKW5rOH69w6Dnl1EwcoqT4 uO8nhDtlTgE3OSUD4NzMzLmlA5jv30pM3yo0aFG6mrEnWhzDRtzyByxwzbEYeVEJ3abvDO4pqudk7 9TuVCcU5lySveUjtbcI0sBxgkgCBTocMAK30c7nvus35fhyMTfrLUhyo6DiueEXDkCgUQH6Kpe3Wc pSBWrdnw==; 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 1u6Rfn-002qf3-22 for pgsql-committers@lists.postgresql.org; Sun, 20 Apr 2025 10:13:15 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1u6Rfn-000w9n-12 for pgsql-committers@lists.postgresql.org; Sun, 20 Apr 2025 10:13:15 +0000 Content-Type: multipart/mixed; boundary="===============8035179029244675904==" 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:13:15 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8035179029244675904== 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 Y29tCkJhY2twYXRjaC10aHJvdWdoOiAxNgoKQnJhbmNoCi0tLS0tLQpSRUxfMTZfU1RBQkxFCgpE ZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi84 ODdhMjMyMzcxNTBiZTUxNGRmMzBiMTEwODRlNjczOGVkNWY5M2UzCgpNb2RpZmllZCBGaWxlcwot LS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9wbGFubmVyLmMgICAgIHwg NTEgKysrKysrKysrKysrKysrKysrKysrKysrKysrKystLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBl Y3RlZC9hZ2dyZWdhdGVzLm91dCB8IDM3ICsrKysrKysrKysrKysrKysrKysrKysrCnNyYy90ZXN0 L3JlZ3Jlc3MvZXhwZWN0ZWQvc3FsanNvbi5vdXQgICAgfCAyNCArKysrKysrLS0tLS0tLS0Kc3Jj L3Rlc3QvcmVncmVzcy9zcWwvYWdncmVnYXRlcy5zcWwgICAgICB8IDE5ICsrKysrKysrKysrKwo0 IGZpbGVzIGNoYW5nZWQsIDExNSBpbnNlcnRpb25zKCspLCAxNiBkZWxldGlvbnMoLSkKCg== --===============8035179029244675904==--