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 1vfo67-00580m-0V for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Jan 2026 23:46:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vfo64-006t5s-39 for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Jan 2026 23:46:49 +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 1vfo63-006t5i-35 for pgsql-hackers@lists.postgresql.org; Tue, 13 Jan 2026 23:46:48 +0000 Received: from fhigh-b8-smtp.messagingengine.com ([202.12.124.159]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vfo61-000HbM-1y for pgsql-hackers@postgresql.org; Tue, 13 Jan 2026 23:46:47 +0000 Received: from phl-compute-05.internal (phl-compute-05.internal [10.202.2.45]) by mailfhigh.stl.internal (Postfix) with ESMTP id 19E0C7A0059; Tue, 13 Jan 2026 18:46:45 -0500 (EST) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-05.internal (MEProxy); Tue, 13 Jan 2026 18:46:45 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1768348004; x=1768434404; bh=0ckgziWh2G 81YRVnKQgQbsKpeLz97jN8ijwhA0Sedv0=; b=N4XpznqRareIRVbrYCs4ILG1cs k35tplQCJEatpv3RE3PPhbKROstLXKYOZIEAHZwnbGSoiDF32M8h6RlY4vMVVlYL DgUIKXn5m5xWo65U3k8BAZOfDMH8v/04Kj4G3T6SRO9vlRWaaSGjdZCXavaqfKdy IP7H3HAa0lE6QNvZldTV0dvc7AxDMgcdhMammp9r24bsDfhOI0ogkBmbQK9Eouxc K77jV4ZT+yFfepPISLZ/y8MjBLIBGEq/xV8vMWeND0R9fMQ7EiRlePN6gXz8Hh+e fpAoNCuCc4p4j+Hv2QIF+YuV6EmuH5W10UmDZiYV9hbQ+aaMmjZcfIGBMllQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1768348004; x=1768434404; bh=0ckgziWh2G81YRVnKQgQbsKpeLz97jN8ijw hA0Sedv0=; b=xOKIdXoOA7iJMcEOCnPsd647d00mEP53QPXJcrn15C8r/iWCPq3 zALG7bHrEdQnav+3zroDniV//mFyxJWGCJr0/45Y4hTdO+WNosx46VF+EE4WWzla PD4vVpSSt5Xh6KnObF1XPx5oyOmIhxWkv5G505bBHipWnby5UDRRWQRcnmAcq92K Hm4S+fqnX64ihapT6SxsNi4vg/ysCXpJ7W314zWFIkN2Zs/441abJfKu4zov9RJI 4Kmznt5ogZlky/p0nQTtEuZRwF0GA/Ftn8LIWFewmkfWqELuNnvRY8XfSC/+KebP 1oLLwEQAdUvfW4tF31IXyNvPBRfND602Fgg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdduvdduieekucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvve fukfhfgggtuggjsehgtdorredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhi vghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnh epffduleehgefhkeefgfeftdfhkedutddvhfdukeeggeehieekffelhfelkeehteefnecu vehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrg gvlhesphgrqhhuihgvrhdrgiihiidpnhgspghrtghpthhtohepgedpmhhouggvpehsmhht phhouhhtpdhrtghpthhtohepjhhirghnrdhunhhivhgvrhhsrghlihhthiesghhmrghilh drtghomhdprhgtphhtthhopehtghhlsehsshhsrdhpghhhrdhprgdruhhspdhrtghpthht ohepphhgshhqlhdqhhgrtghkvghrshesphhoshhtghhrvghsqhhlrdhorhhgpdhrtghpth htohepghhuohhfvghnghhlihhnuhigsehgmhgrihhlrdgtohhm X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 13 Jan 2026 18:46:42 -0500 (EST) Date: Wed, 14 Jan 2026 08:46:27 +0900 From: Michael Paquier To: jian he Cc: Tom Lane , PostgreSQL-development , Richard Guo Subject: Re: JumbleQuery ma treat different GROUP BY expr as the same Message-ID: References: <2546766.1768063587@sss.pgh.pa.us> <3354376.1768148370@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="O3FnOL1gZcU5r5AX" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --O3FnOL1gZcU5r5AX Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Jan 13, 2026 at 04:09:46PM +0900, Michael Paquier wrote: > I have expanded a bit the tests, with a couple of extra patterns, > giving the attached. The behavior is the same as the pre-v17 > branches. Done this part for the GROUP BY regression now, as of e217dc7484e5, down to v18. -- Michael --O3FnOL1gZcU5r5AX Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmlm2VMACgkQnvQgOdby QH1zxBAAhsBHygDvFYaXN1Aqa0y4Og/fdMbMqT/A187/kFqPNAkGzlWCyBJCWN82 ETP+Ch6FCs3j66S0EbSzvUIwsoo2mtUd1zdAGmxz6v37vJayFYBlUrsxeXCCSIwL dE+OHtGJnkhvxEqF9jp9Htg/hliVRyUin5sfVHwnyPp8jj01KzFUtx/AcZs5mEb7 vpo4GzD/octfnBsaJosuSvnGBXcY/1/A1xnlOLzwVl9+gw+GKlU+sLbsmjwsKuKu AI96AwUJuRP9rqgFZmGFnn8ogV5+6x9bS5a5J4kTii+RMjvyysGTdpLrNuciJHB8 Iv2DC8ZFyTq1fDLBwOp77xZiSpeBk+gWC5o3okr0ip/b3eLi2g+x6laJYgrfKj7P HV36Sx3Apo6q8Q8rc3AZ19vZhIUH+9wItYRChOsLBsdEkjrZ9U7AL5tSDtPzGfAn FWVRf3JBO/ZoZjtW+F/ckpuhS+vCAihTTC1nx+ukPIeo9ZhtAaAk2hwWQtr1qK2s 60H8zg5j2MnhbUrrTmnOUfldj6jhSgrhBlbEgaka9ym2cZmSIVN+d1yta8LyWrBv DYXt4MlWOqpwcgIHziRi3YCx0ot/S50ilq1jRsMzyHvQV9T3VIU1zJS0EsXFSy0Q tMl0LmXc6IhayoQWnSp1AEA2YNLEv2u0aFBIQjY/3lwfivJlcAo= =QKtR -----END PGP SIGNATURE----- --O3FnOL1gZcU5r5AX--