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 1mZwGr-0003qx-1m for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Oct 2021 14:27:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mZwGq-0000Hx-1H for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Oct 2021 14:27:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mZwGp-0000Hl-PS for pgsql-hackers@lists.postgresql.org; Mon, 11 Oct 2021 14:27:15 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mZwGi-0002N8-KH for pgsql-hackers@postgresql.org; Mon, 11 Oct 2021 14:27:14 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id D88135C011A; Mon, 11 Oct 2021 10:27:06 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Mon, 11 Oct 2021 10:27:06 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; bh=BmiZKVLp8dmm/O4/jL5B2q2Umgh/QdoMC+KmocHvr lU=; b=HPVqOTi2tuhOT/q05kJ2tRe7S0lRnk3J8P9y9CydOy25XlsB86G3CVw9V uN/C0qXdTGCFnDVthXjJMAzbeSydcdoN1wLVh6wMPhyUcX394Z1wlroyeYfrWi3p bILGAkM97MQWnCNixH6i+Fjt3IuXFEApygxjJi2XU6cWEID7Icx2XuDOSiWO6i2J vqcR2GKsT1R65nDbyYI7QMjsVYlM8RSN4A2FfxbBzAC4uPLjo/In+Y4f9e7kt2ZZ owRXArYUd+GZ2VG86cxMn3NcZcpjlVy5ipO+kmj4jGXmoEpWi3NHgmFqcHwJWY0M 5bZBl3maOaxwNsj/wz7xO9vvQos2A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrvddtiedgjeduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffvfhfhkffffgggjggtgfesthejredttdefjeenucfhrhhomheprfgvthgv rhcugfhishgvnhhtrhgruhhtuceophgvthgvrhdrvghishgvnhhtrhgruhhtsegvnhhtvg hrphhrihhsvggusgdrtghomheqnecuggftrfgrthhtvghrnhepleevheehueeiudeiteei tdekueetleefteejffeiffdugedvffdvffdtiedvueeknecuvehluhhsthgvrhfuihiivg eptdenucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhdrvghishgvnhhtrhgruhht segvnhhtvghrphhrihhsvggusgdrtghomh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 11 Oct 2021 10:27:04 -0400 (EDT) Subject: Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails To: Markus Winand , Pgsql Hackers Cc: Tom Lane , Andrew Dunstan , torikoshia References: <5bafa66ad529e11860339565c9e7c166@oss.nttdata.com> <3208199.1631039493@sss.pgh.pa.us> <24ce73f9-c714-9a7c-6cc0-34e724c8f1c9@dunslane.net> <984394.1631719708@sss.pgh.pa.us> <1126187.1631749231@sss.pgh.pa.us> <7da9d40759bab675e57ab495499720c1@oss.nttdata.com> <648B0505-AA57-42C2-A2DA-E551DE46FA15@winand.at> From: Peter Eisentraut Message-ID: <7a0597fb-edb8-6074-a9c7-11d41b3ae849@enterprisedb.com> Date: Mon, 11 Oct 2021 16:27:03 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0) Gecko/20100101 Thunderbird/78.13.0 MIME-Version: 1.0 In-Reply-To: <648B0505-AA57-42C2-A2DA-E551DE46FA15@winand.at> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 11.10.21 12:22, Markus Winand wrote: > Both variants work fine before that patch (4ac0f450b698442c3273ddfe8eed0e1a7e56645f). That commit is a message wording patch. Are you sure you meant that one?