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 1mXwRy-0002w9-PD for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Oct 2021 02:14:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mXwRx-0004QO-OQ for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Oct 2021 02:14:29 +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 1mXwRx-0004QF-4x for pgsql-bugs@lists.postgresql.org; Wed, 06 Oct 2021 02:14:29 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mXwRt-0000io-Dq for pgsql-bugs@lists.postgresql.org; Wed, 06 Oct 2021 02:14:28 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 67CAA3201C36; Tue, 5 Oct 2021 22:14:22 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Tue, 05 Oct 2021 22:14:22 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=00pPQodC+N6O1JWLT2prfzX07Ci 5twiWPXEfD6imq0U=; b=btdYw25R3Vg0jXdtOOiFn03lIDK/SWHoNlaNOlC/L9K XONohP9iG1QDEXlbzzxazQcwDnJ3ENcIZWtVxg6Qt5PDMeo/RQJR06uXRmkdiXIB reiMEX3EbGTIjztkx0QP7jaDPyEJvGtRHEJ9NY7BhwO9+ZsX7krmAJcjDJYf+tyi rbgTOthw3tW3ogAUrf85ebZr6s029GHo2JIAmzCZc1QteWw4Je8hV1kht+WVUazl Io3mJl/Rm+Xr1r/YTCrFBxDinc737EIhNvWjee3XDCN0kbvUORzfPzT2+GV6lfao qRmOTd/MGNqJNW88MKxLfZ61WJI1SYwQ53qjYrQMfeQ== 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-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=00pPQo dC+N6O1JWLT2prfzX07Ci5twiWPXEfD6imq0U=; b=mA8L9h/TysoIoRMBropBCl xHyd3UZxrdL3P9whw0r/87XeysQwyisD+Muh1bbYfIQuD2GMb+QWwf8oopgmIohZ 85GljvwQUp9iJ0NBV5qy3+bcKTWMJxoCXVFNHmUsI0tqDBOmf5Fziw6cGfXnQwB9 ZYKLFc+88Cep4ASyya6pEsv4EPNRDCA6vJm2EsvNx5xgPbosVWlVCfc7WfE8TxEj Bldffowqp5A56m6A06XvQFgZmiVtMEhhzB6jI72Vr8c4CCqN6CszCwtSg5wpso+x tbOxYCd38nDzjjEewTZJVGDdmcKC2hneKzxmqmCzo8innhBNLQPHzAdkDniMa9uQ == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrudelhedgheegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 5 Oct 2021 22:14:20 -0400 (EDT) Date: Wed, 6 Oct 2021 11:14:17 +0900 From: Michael Paquier To: james@jlr-photo.com, pgsql-bugs@lists.postgresql.org Cc: Peter Geoghegan , Heikki Linnakangas Subject: Re: BUG #17215: ltree tests failing in REL_14_STABLE / commit cb8a5a588 Message-ID: References: <17215-172d40d74040a0bf@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="55MpMXASfmlNDNPQ" Content-Disposition: inline In-Reply-To: <17215-172d40d74040a0bf@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --55MpMXASfmlNDNPQ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Oct 05, 2021 at 10:21:46PM +0000, PG Bug reporting form wrote: > When running the contrib/ltree checks against a build on OSX 10.13 (yeah,= I > know) against commit cb8a5a588e in REL_14_STABLE, am dying due to:=20 >=20 > # SELECT * FROM ltreetest WHERE t =3D '12.3' order by t asc; > ERROR: unrecognized StrategyNumber: 6 Adding Peter and Heikki here. That may look like a corruption, but by re-running the tests this is reproducible, right? Are you running a simple "make check"? Perhaps you forgot to clean up your source directory before recompiling? Or is that an installcheck on an existing instance, which has some particular configuration not checked in the buildfarm? This query uses only BTEqualStrategyNumber here. Now, it seems to me that this could point to an actual bug, where the consistent function tries to use a picksplit, but it should not in a certain code path. I am not really a gist expert, just saying, but there are diffs between 13 and 14 in this area. -- Michael --55MpMXASfmlNDNPQ Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmFdBnkACgkQnvQgOdby QH2Vig//b0L8L8ys5QyBecx42aXKLr2kq5oGG/Wx+xB5msGKcGtHy1LX8eHj+L7a /oB+Dn84QaLL9tyehzExM484Zr8IbHgbT0W6Zt4aFwLjzqzO7iMMpHimJmPZ1ivM /IP76NJAElpV2naU7ZpJRnLSLzZKlyiP9IFbgZJE0kPQxlSLeYBfZpFiPCPCQP0b nIX8I2EJYfG0OKw6IX2E4yWHSRYg4VBBmmff4vQULD7X+M7fHTDRp84/fMBTfQa8 T++dhl03GysMfWWa9w/ZhuCDFf0ieq2xXw2/kdR2mDJMdN2MnmCFbuTeUTymun9D cO0DFtRx0l7jn6SVdAxx85lKF2QD4aNUIzT7ABa26zKr04XBvwVzXd/Ei5kVsOyP +GNDmhzqB6OMMer16tXJqstbATcqXFoQfReWHlHDhLg+LoCMG+B4iVBVkqO2kKLA hjxoWSSmWKSuVWUg2sXpNanefwAZDSqn+fprhT/j3pfr5LD3AMyfgdlMQ4I8wxKe Goj2qTK4IuWSpPFfgAXGE4C7dV4aasEdkIqSHpePTixDRu0AQlq56WFlRt5WgasZ WuznKwhj89wMVt7VzjnNt4mU/WxtZnnLIowUAX+BeeOhcXBjhN3uhtE+7dWJnw5i JHn3Yw6hkoknkbyyguubyEIeK/gKA43vMXYuJcpizPUoIUTT9gk= =ubIJ -----END PGP SIGNATURE----- --55MpMXASfmlNDNPQ--