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 1v2AwW-00147i-IA for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Sep 2025 16:05:08 +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 1v2AwU-003fos-JZ for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Sep 2025 16:05:07 +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 1v2AwU-003foj-AR for pgsql-hackers@lists.postgresql.org; Fri, 26 Sep 2025 16:05:06 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v2AwS-000Fg9-18 for pgsql-hackers@postgresql.org; Fri, 26 Sep 2025 16:05:06 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 58QG4sVN4083064; Fri, 26 Sep 2025 12:04:54 -0400 From: Tom Lane To: David Christensen cc: Andrey Borodin , Peter Eisentraut , pgsql-hackers , "David G. Johnston" , Jelte Fennema-Nio Subject: Re: [PATCH] GROUP BY ALL In-reply-to: References: <4D2047B0-E8D8-472B-B7E8-61206B1E6AFA@yandex-team.ru> Comments: In-reply-to David Christensen message dated "Fri, 26 Sep 2025 10:45:53 -0500" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <4083062.1758902694.1@sss.pgh.pa.us> Date: Fri, 26 Sep 2025 12:04:54 -0400 Message-ID: <4083063.1758902694@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk David Christensen writes: > Here is a rebased version with a few more tests. I also changed the > main check here to using `!contain_agg_clause` instead of > `!IsA(Aggref))` directly. (This was defined in `optimizer/clauses.h`, > but we already are pulling in `optimizer.h`, so it felt valid to me.) contain_agg_clause will blow up on a SubLink, so I doubt this is gonna be robust. regards, tom lane