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 1k3Q4u-00020O-4Y for pgsql-bugs@arkaria.postgresql.org; Wed, 05 Aug 2020 20:32:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k3Q4s-00047J-Ot for pgsql-bugs@arkaria.postgresql.org; Wed, 05 Aug 2020 20:31:58 +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 1k3Q4r-00047C-N7 for pgsql-bugs@lists.postgresql.org; Wed, 05 Aug 2020 20:31:58 +0000 Received: from mail.dalibo.com ([212.85.157.172]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k3Q4k-0005Go-Te for pgsql-bugs@lists.postgresql.org; Wed, 05 Aug 2020 20:31:56 +0000 Received: from firost (abordeaux-652-1-127-47.w2-6.abo.wanadoo.fr [2.6.166.47]) by mail.dalibo.com (Postfix) with ESMTPSA id 492B21FA64; Wed, 5 Aug 2020 22:31:45 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=dalibo.com; s=a; t=1596659505; bh=ckziaF2UxaNvDo7G1pR1BaBnYjaZI/+P6N03TXv1vR0=; h=Date:From:To:Cc:Subject:In-Reply-To:References:From; b=kaakwn5ezjyI5juPjQg7upvSLeVmsc0M8jQslOwqIHbG03FXKkgur4bKROUiwm/yv VPL8euTN2+rpTCzlRp4hNOrKiWuAE+M+6Qkj5CtjZ4tBN+vgI6/PVvjUQIP8tf0C9d /Hk+Pso6tIrJ27CoxyHddON0Fkjo26lw6k5UxdUY= Date: Wed, 5 Aug 2020 22:31:42 +0200 From: Jehan-Guillaume de Rorthais To: "Daniel Verite" Cc: "Arnaud Perrier" , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16570: Collation not working Message-ID: <20200805223142.5789792d@firost> In-Reply-To: <118c09c5-3334-4570-8644-7c5300fbc0f2@manitou-mail.org> References: <118c09c5-3334-4570-8644-7c5300fbc0f2@manitou-mail.org> Organization: Dalibo MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, On Wed, 05 Aug 2020 16:49:49 +0200 "Daniel Verite" wrote: [...] > I'm wondering whether there is a discrepancy between the binary > sort keys and results of direct comparisons by ucol_strcoll() > for this collation. [...] This bug has been discussed back in 2018 and a customer hit it few weeks ago as well. Here is my last analysis, various link to histories, a workaround and a even an humble patch proposal to discuss: https://www.postgresql.org/message-id/flat/20200610002933.6a6d482b%40firost#acba071ed158e0c03ea9a106d9b0fd6d I even sent a patch to the ICU community to add a regression test exposing the bug, but I had no answer. Hopefully the workaround is good enough for you. Regards,