Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPWVc-0006Pf-Lu for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Feb 2023 22:32:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pPWVb-00039P-Ir for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Feb 2023 22:32:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPWVb-00039G-9U for pgsql-hackers@lists.postgresql.org; Tue, 07 Feb 2023 22:32:15 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPWVY-0006KI-Vc for pgsql-hackers@lists.postgresql.org; Tue, 07 Feb 2023 22:32:14 +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 317MW7gr3344828; Tue, 7 Feb 2023 17:32:07 -0500 From: Tom Lane To: Michael Paquier cc: Peter Eisentraut , Postgres hackers , "Drouvot, Bertrand" Subject: Re: Generating code for query jumbling through gen_node_support.pl In-reply-to: References: <50b571dc-e0c0-22be-9803-4a3480d2e792@enterprisedb.com> <9695f035-0f2b-92b9-deed-0b7e5bb7e4e0@enterprisedb.com> <268fd337-8bb7-92e6-0da2-416c022c11f3@enterprisedb.com> Comments: In-reply-to Michael Paquier message dated "Tue, 31 Jan 2023 15:40:56 +0900" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <3344826.1675809127.1@sss.pgh.pa.us> Date: Tue, 07 Feb 2023 17:32:07 -0500 Message-ID: <3344827.1675809127@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Michael Paquier writes: > With all that in mind, I have spent my day polishing that and doing a > close lookup, and the patch has been applied. Thanks a lot! I have just noticed that this patch is generating useless jumbling code for node types such as Path nodes and other planner infrastructure nodes. That no doubt contributes to the miserable code coverage rating for queryjumblefuncs.*.c, which have enough dead lines to drag down the overall rating for all of backend/nodes/. Shouldn't a little more attention have been paid to excluding entire node classes if they can never appear in Query? regards, tom lane