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.96) (envelope-from ) id 1whGJb-0007At-2o for pgsql-committers@arkaria.postgresql.org; Wed, 08 Jul 2026 00:39:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1whGJa-003wKf-13 for pgsql-committers@arkaria.postgresql.org; Wed, 08 Jul 2026 00:39:03 +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.96) (envelope-from ) id 1whGJZ-003wKJ-2t for pgsql-committers@lists.postgresql.org; Wed, 08 Jul 2026 00:39:02 +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.98.2) (envelope-from ) id 1whGJX-000000004Q3-3tVs for pgsql-committers@lists.postgresql.org; Wed, 08 Jul 2026 00:39:01 +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=tE5Rq1naC4lRV3DuOCX5ROCbXveVGq14PV66g6ASzEo=; b=WiCOdXXiQ4fNqFoCPaPJQ1y5Be Vle0RKqf6+6X+GF6dNxVIXA2CEphpDAGqN0XgukZ7h6ZO9XkwK/DoGi3isktMPHoanc/J1A5qLCE4 IqY53qD+agO/Dfe4aKJlqQ4U1Fjo8q5KjODhd8drFE7B/Cqye91IAkYt0pbK4VTODTjVxroNv3gdQ Q+RCmfsq49xtcnvM5M9wm+uPK24a99tOWkMVfRYWF5zqQTPCNqXqxQSyLy2BBz73UlelCAgjzyuwe 22986Xgf0zc0/CwIHUZU2ZnAynWHoZcAmmoqPs4m/fK//olxRDhnP4AHQFxfzH/14CZeo+9O9bRnM qbS1FPjQ==; 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.96) (envelope-from ) id 1whGJX-000J2n-1n for pgsql-committers@lists.postgresql.org; Wed, 08 Jul 2026 00:38:59 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1whGJW-0004fK-2b for pgsql-committers@lists.postgresql.org; Wed, 08 Jul 2026 00:38:59 +0000 Content-Type: multipart/mixed; boundary="===============5904438508427055623==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Propagate stadistinct through GROUP BY/DISTINCT in subqueries an X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 08 Jul 2026 00:38:59 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5904438508427055623== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UHJvcGFnYXRlIHN0YWRpc3RpbmN0IHRocm91Z2ggR1JPVVAgQlkvRElTVElOQ1QgaW4gc3VicXVl cmllcyBhbmQgQ1RFcwoKUHJldmlvdXNseSwgZXhhbWluZV9zaW1wbGVfdmFyaWFibGUoKSB3b3Vs ZCByZXR1cm4gZWFybHkgd2hlbiBhCnN1YnF1ZXJ5IG9yIENURSB1c2VkIEdST1VQIEJZIG9yIERJ U1RJTkNULiAgSXQgY291bGQgZGV0ZWN0IHVuaXF1ZW5lc3MKZm9yIHNpbmdsZS1jb2x1bW4gY2Fz ZXMsIGJ1dCBmb3IgbXVsdGktY29sdW1uIEdST1VQIEJZIG9yIERJU1RJTkNULApzZWxlY3Rpdml0 eSBlc3RpbWF0aW9uIGZlbGwgYmFjayBvbiAxL0RFRkFVTFRfTlVNX0RJU1RJTkNUICgxLzIwMCku ClRoaXMgcHJvZHVjZWQgd2lsZGx5IGluYWNjdXJhdGUgZXN0aW1hdGVzIGZvciBmaWx0ZXJzIGFu ZCBqb2lucyBvbgpzdWNoIGNvbHVtbnMsIG9mdGVuIGxlYWRpbmcgdGhlIHBsYW5uZXIgdG8gY2hv b3NlIG5lc3RlZCBsb29wIGpvaW5zCndoZXJlIGhhc2ggam9pbnMgd291bGQgYmUgZmFyIGJldHRl ci4gIFRoaXMgd2FzIGEgc2lnbmlmaWNhbnQgZmFjdG9yCmluIHBvb3IgVFBDLURTIGJlbmNobWFy ayBwZXJmb3JtYW5jZS4KCkZvciBESVNUSU5DVCBvciBHUk9VUCBCWSBrZXkgY29sdW1ucyB0aGF0 IGFyZSBzaW1wbGUgVmFycywgd2Ugbm93CnJlY3Vyc2UgaW50byB0aGUgc3VicXVlcnkgdG8gb2J0 YWluIHRoZSBiYXNlIHRhYmxlJ3Mgc3RhZGlzdGluY3QsCndoaWNoIHJlbWFpbnMgdmFsaWQgYWZ0 ZXIgZ3JvdXBpbmcgKHRoZSBzZXQgb2YgZGlzdGluY3QgdmFsdWVzIGlzCnByZXNlcnZlZCkuICBI b3dldmVyLCBNQ1YgZnJlcXVlbmNpZXMsIGhpc3RvZ3JhbXMsIGFuZCBjb3JyZWxhdGlvbgpkYXRh IGFyZSBub3QgdmFsaWQgYmVjYXVzZSBHUk9VUCBCWSBhbmQgRElTVElOQ1QgY2hhbmdlIHRoZSBm cmVxdWVuY3kKZGlzdHJpYnV0aW9uIG9mIGtleSBjb2x1bW5zLiAgU28gd2Ugc3RyaXAgYWxsIHN0 YXRzIHNsb3RzIGZyb20gdGhlCmNvcGllZCBzdGF0cyB0dXBsZSwgY2F1c2luZyBjYWxsZXJzIGxp a2UgdmFyX2VxX2NvbnN0KCkgdG8gdXNlIHRoZQoxL25kaXN0aW5jdCBlc3RpbWF0ZSBpbnN0ZWFk LiAgSWYgc3RhZGlzdGluY3QgaXMgc3RvcmVkIGFzIGEgbmVnYXRpdmUKdmFsdWUgKGEgZnJhY3Rp b24gb2YgdGhlIGJhc2UgdGFibGUncyByb3cgY291bnQpLCB3ZSBjb252ZXJ0IGl0IHRvIGFuCmFi c29sdXRlIGNvdW50IHNvIGl0IGlzIG5vdCBtaXNpbnRlcnByZXRlZCByZWxhdGl2ZSB0byB0aGUg c3VicXVlcnkncwpvdXRwdXQgcm93IGNvdW50LgoKc3RhbnVsbGZyYWMgaXMgYWRqdXN0ZWQgdG9v LCBzaW5jZSBncm91cGluZyBjb2xsYXBzZXMgTlVMTHMuICBGb3IgYQpzaW5nbGUgZ3JvdXBpbmcg a2V5LCBhdCBtb3N0IG9uZSBOVUxMIGdyb3VwIHN1cnZpdmVzLCBzbyB0aGUgbnVsbApmcmFjdGlv biBpcyAxLyhuZGlzdGluY3QrMSkuICBGb3IgbXVsdGlwbGUgZ3JvdXBpbmcga2V5cyB0aGUgbnVs bApmcmFjdGlvbiBkZXBlbmRzIG9uIHRoZSBqb2ludCBkaXN0cmlidXRpb24gb2YgdGhlIGtleXMs IHdoaWNoIHdlIGRvbid0CmhhdmUsIHNvIHdlIGFwcHJveGltYXRlIGl0IGFzIHplcm87IE5VTExz IGNvbGxhcHNlIGZhciBtb3JlCmFnZ3Jlc3NpdmVseSB0aGFuIG5vbi1OVUxMcywgc28gdGhlIHJl YWwgZnJhY3Rpb24gaXMgd2VsbCBiZWxvdyB0aGUKYmFzZSB0YWJsZSdzLCBhbmQgZXJyaW5nIGxv dyBrZWVwcyBlc3RpbWF0ZXMgb24gdGhlIGhhc2gtam9pbi1mYXZvcmluZwpzaWRlLgoKTm9uLWtl eSBjb2x1bW5zIChlLmcuLCBhZ2dyZWdhdGUgb3V0cHV0cykgY29udGludWUgdG8gZ2V0IG5vIHN0 YXRzLApzYW1lIGFzIGJlZm9yZS4KCkF1dGhvcjogUmljaGFyZCBHdW8gPGd1b2ZlbmdsaW51eEBn bWFpbC5jb20+ClJldmlld2VkLWJ5OiB3ZW5odWkgcWl1IDxxaXV3ZW5odWlmeEBnbWFpbC5jb20+ CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FNYldzNDlyV1lyZWNncmVEaEtzZngz VlNEVz1xbzM1cytpQW1nR3U9d3BBUnJNOF9nQG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0t Cm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2Nv bW1pdGRpZmYvOTA2YjFlNGExOWE1OTYxMmRlYjE0NGZmNjAxOGNiMDQ4ZjdkNzNmOAoKTW9kaWZp ZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvdXRpbHMvYWR0L3NlbGZ1bmNzLmMg ICB8IDEyMiArKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKy0tLS0tCnNyYy90ZXN0L3Jl Z3Jlc3MvZXhwZWN0ZWQvd2l0aC5vdXQgfCAgOTQgKysrKysrKysrKysrKysrKysrKysrKysrKysr KwpzcmMvdGVzdC9yZWdyZXNzL3NxbC93aXRoLnNxbCAgICAgIHwgIDM1ICsrKysrKysrKysrCjMg ZmlsZXMgY2hhbmdlZCwgMjM3IGluc2VydGlvbnMoKyksIDE0IGRlbGV0aW9ucygtKQoK --===============5904438508427055623==--