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 1jy2kE-0002qm-51 for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Jul 2020 00:36:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jy2kC-000705-70 for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Jul 2020 00:36:24 +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 1jy2kB-0006y1-W0 for pgsql-hackers@lists.postgresql.org; Wed, 22 Jul 2020 00:36:23 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jy2k9-0005IA-2H for pgsql-hackers@postgresql.org; Wed, 22 Jul 2020 00:36:23 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 244D55C012D; Tue, 21 Jul 2020 20:36:19 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Tue, 21 Jul 2020 20:36:19 -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=wtJl78qd7zbMlGIrhf7WhLrJZyS IywmZUbRqdofExJ8=; b=QHZyn8cogkX+lND7o5ciOHCdUSMQHyEdbZNQbjz6fbM obkB6lUEck0yiH4z7Q0t38VxbNRZPSkSS104UOAj2ntWSv4lkWYm/byKk6uBcrqa p+JQGiftnZxRG9dY+nabpG/gEXFhoOcpOGUd8fYL7OASKXrZAaXdiqf2g11AHAgx 2oQ7+9PZURbLibe2ic9liLvyqguEFzpxn8ELdp/NVtbcjXAE0f8Cdm1cU2MJWH8g RDNWsKJiA2jH+qSzGZjV+bZoSy+c2uGk1yj0Due/eAYvXL7U+KHWz5KJv3KjT3eo VdPSzfk47URC4Njjd3sou4dn4Lfgcei5nMzwA6kqeOQ== 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=fm3; bh=wtJl78 qd7zbMlGIrhf7WhLrJZySIywmZUbRqdofExJ8=; b=DPWKZBbkE9WSd9fZDDMmro tEEidQ83Cl3TqIvHbz+TV8G65Biyuai1Xa1fWsx9kKsrqMBTM4sRm/Uznw2oyEWg 7s+MckXvCgGJdoRIXC6RjC2fYkWpehH+Bz9Oo5VuUjipWCgeMZDjpJ83zMpBNtBK ntMcMeTAdobwaiarVnJ6BO+KuFwY5flCdnRdaEnvonRUiJbMxfahhd/fZwe10hhO KYvgydV8p4mJW/6ZE8VwiQJ8kZQbUq09rGxW3QbcQCQ7ayRkAOkbXjPTVMDny47/ 6LYCjgXXay6W4tZXO0K5SORstbtO2rWkXRooRiX1prJgGlhPFmJ4nGa6vx5Vmbng == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduiedrgeekgdefiecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepvdegudeuhfdtueeltedtveejheeh ieevueeigeelteegleejleeiueeiheegvefhnecukfhppeduuddurddutddvrddukedtrd dukeehnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhep mhhitghhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 714B33280059; Tue, 21 Jul 2020 20:36:16 -0400 (EDT) Date: Wed, 22 Jul 2020 09:36:12 +0900 From: Michael Paquier To: Tom Lane Cc: Justin Pryzby , pgsql-hackers@postgresql.org Subject: Re: v13 planner ERROR: could not determine which collation to use for string comparison Message-ID: <20200722003612.GC9642@paquier.xyz> References: <20200721191606.GL5748@telsasoft.com> <1199426.1595370300@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="8w3uRX/HFJGApMzv" Content-Disposition: inline In-Reply-To: <1199426.1595370300@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --8w3uRX/HFJGApMzv Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Jul 21, 2020 at 06:25:00PM -0400, Tom Lane wrote: > Ugh. It's clear from your stack trace that neqjoinsel() has forgotten to > pass through collation to eqjoinsel(). Will fix. Why didn't you include a regression test in bd0d893? -- Michael --8w3uRX/HFJGApMzv Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl8XifwACgkQnvQgOdby QH0+Ew//QYatLLM2t86WvR0EW6INoL9uH/bptWEPYHP5+tXVR7aPIs9usqrG/MHh 2nmIGCTwDpXMPnI6zTT3L4cthgEHxB6XesnCCUUltqX9YXxWSFKOAijJELtofNSu xjAKjlDV/P9rPIPzBtzOKDQO6s+HmNU5IbGG8jsv8DyhmyuoDVGAP5Gy8nWKe/oG xM0BYt9u3pdkg5jkUPvM1oWUeoER7/RDwYs6yqNYC62At0x/oO8x96xGBeMJq7+T BDXFBFZAlZ9ZmUxtllmPCLWbLRxEX/npE++TnwwC++bQlmBR80XegOAPsI0Trvgg 8OePj2bsVyFGwck6bA97KpiMTaHskZ6mIZLivzyIKb7p7khdR31azboU1ruFZNz9 XljYk6CelWyTtaG9QAUOdJKIwyHFyDpvZ5jCfRs3/oTfejaBmDH68fN8GSsva/5c iyRVu1NlEwPjtd15S0z9buM2vOepqy5HJnMWe+Wnp67tB5fcyHJ1kEO4TpoXQog8 UTOEpbQrsimR4aMwNeY6AA36QTcBr6zfx0435quGWxGeB55Ri6mP+eMgmP+6G8hb i+/wIgtdD9Zvi1g8K/RDliuvWbZ71ncllVM6G8kBgMWDql5m1jegygb8nc+uFm/9 H4PJCcl/fPFKt4TAMDVs65IeVTOHo//VctYO8h04P/a35CQaTlU= =x1Rp -----END PGP SIGNATURE----- --8w3uRX/HFJGApMzv--