Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fg2P4-0004T1-Dx for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Jul 2018 06:27:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fg2P2-0002XI-UR for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Jul 2018 06:27:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fg2P0-0002XB-QZ for pgsql-hackers@lists.postgresql.org; Thu, 19 Jul 2018 06:27:04 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fg2Ov-0005uG-41 for pgsql-hackers@postgresql.org; Thu, 19 Jul 2018 06:27:02 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id A98DA21C64; Thu, 19 Jul 2018 02:26:54 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Thu, 19 Jul 2018 02:26:54 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=B0693v1amQX48A8Hc50poyC222yyBxKQZrt/vSYrQA0=; b=w6rjEQ6g OrDdPV4qBHbXG5k8jcHmBYCR814OjCRM8YL73gbdmP8XFsq1fcMZD5PE8Xcm9RrE WI8xTjgBXWWeWzaYO+qlgr5cOBiRxQ8Fhoxng7fUv3/4MMLai/TsLteLTiebBvh3 ZFVmu7qSqoupgnMeHLvGVnhwZPOLfggwYW47tlrfcDITMK6XPgJhL8eTPbZy8V+2 5TimuYMvU59MEEUd047TUn8sZ9LF/YmxX8aitwV4LJOzOqDLqC6IulccuGcyvr0i 1h53K29HObtYoB1NFcaxq2PwbxIzzGW8En1cafDmB2PKfPn6Vy06Jk9iq4iPPEoe tOxR1cj3ndX+bA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; bh=B0693v1amQX48A8Hc50poyC222yyB xKQZrt/vSYrQA0=; b=qtNqRXuuEL8xVmsp4v0Vg7tqIAjq5mx/quABZ80AtolWu tMbNszYd3RSsJAKIx0ikyygWZkNdrRRZtphnjhilXlqO77FYfnu/ubULnX1Y4TSD KjyEdEOJQ9BCxYt3xWKTOlmtUBfCm+B0JVcpZwDaxgvfRodb+pKBNuOd/NwzUWEe OhOjZmz0WAL9Ru7gIKoSyLorU4E8qusuk79ct1FPYfNcY9xy7SEcoS1ZJLr5kFPd TzS97PyUv+2wzOMBX28DoVvS0LeyTu3yeo4CndZkTkDLETdozV1iRLEJMDfH/iM2 Wwp8g/qCw9AFCAlRMiSXSyfsuhByjVT/s7taVbW1w== X-ME-Proxy: X-ME-Sender: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 17D551026A; Thu, 19 Jul 2018 02:26:52 -0400 (EDT) Date: Thu, 19 Jul 2018 15:26:50 +0900 From: Michael Paquier To: Ashutosh Bapat Cc: Masahiko Sawada , PostgreSQL-development , Robert Haas Subject: Re: print_path is missing GatherMerge and CustomScan support Message-ID: <20180719062650.GL3411@paquier.xyz> References: <20180718062202.GC8565@paquier.xyz> <20180719000722.GA3411@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="HVCoas+krw6dou6l" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --HVCoas+krw6dou6l Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Jul 19, 2018 at 10:41:10AM +0530, Ashutosh Bapat wrote: > I had extensive testcases in my original patch-set to exercise that > code but 1. that testset was too extensive; even today > partition_join.sql is a separate testcase and it's quite large. 2. > that function returns NULL rather than throwing an error, if it can > not produce a parameterized path. So, unless we check whether each of > those paths get created no test is useful and that can only be done > through an EXPLAIN OUTPUT which means that the testcase becomes > fragile. I fine if we want to add more tests just to cover the code if > those are not as fragile and do not blow up partition_join too much. Did those really check the reparameterization of a MergeAppendPath for a child of the parent? I'd be surprised if this one was stressed as there was no match in the list. -- Michael --HVCoas+krw6dou6l Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAltQLyoACgkQnvQgOdby QH0VjQ//fD7ahucQdV/pRbjg7vT+Uir1s0O3jCEmJKZE/BxEa7NvfdbsPlOpUJjH HqiduLy1EtE32mAvnp7C6TtKQ/xXu8DKuaydC9KlCMxE7MB1Bqi5HlocbmE9Q0PJ Ka44OViL+fMbtrkW7L65HzPSRRtaOy+7/ErsgmGcAj6UvTTxfP9gTBoXtnwGW633 7jlS93BncWM9WGYg3DrkNuC5x2e6f0NzCcCa8Ztl84jFYVs0WJVq0766jWB6ORyb ysb0DqQwvzwnwxYbH2fVcWkDBeGQuZLBoNMKSK1nr63If2m5lH5p4BwtFr84GXwa mKw+be6886m9J9TMKU+qTbUAlr7p6Bu5gDta32KGWWs4XEnAMVGzcChyB+WlCrO7 8HwWS8I2Qj+sK2Jul/vte4tURnGVyApJ1kJcPIL4UAGtgdE6uqzdvaCId9l2eKMv LMyH2+GX9zaj240gJasup0pBz6ldZT8JZGFbktFAh7pyUYgHS4JlCOY/n8E/Ou6C lmPiAt/mA9JMBY7SqRAU/3K2+wZxWeJJZ823o/iWz/HyqozcJgkBt9cWnOwHsHCu 16Jv3SxgACiPUFFeqtq7sKGaE5ZbQXwKqFuhazAZ/SOBhsFlkBAhLvY19R/Fn4uy Vpw3k+ObRA5tMTBK2QdUa/HU4Hsu7ZytheourFN10X0Y9ICKzwQ= =geHb -----END PGP SIGNATURE----- --HVCoas+krw6dou6l--