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 1kG2pN-0005qB-2U for pgsql-bugs@arkaria.postgresql.org; Wed, 09 Sep 2020 16:20:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kG2pM-0007i4-0U for pgsql-bugs@arkaria.postgresql.org; Wed, 09 Sep 2020 16:20:08 +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 1kG2pL-0007hx-FJ for pgsql-bugs@lists.postgresql.org; Wed, 09 Sep 2020 16:20:07 +0000 Received: from mail.dalibo.com ([212.85.157.172]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kG2pJ-0000RL-9y for pgsql-bugs@lists.postgresql.org; Wed, 09 Sep 2020 16:20:07 +0000 Received: from firost (larco.ioguix.net [82.66.0.6]) by mail.dalibo.com (Postfix) with ESMTPSA id 59DB12047E; Wed, 9 Sep 2020 18:20:03 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=dalibo.com; s=a; t=1599668403; bh=LjwrcBsl858osEPnlgehUVcJFRheCXbtWwh9+pIJU00=; h=Date:From:To:Cc:Subject:In-Reply-To:References:From; b=gOjEIbSWoLARXsHjfFYifaBEQHTr1XS0nMeRNAXlVx/JonUKvweGoQOzRuDPTBGs4 pMIo3F/QXg1w/t/9NK+nA3CA3BVrZitlTOsfY64BGtzpRhc9caGNnBM4BQnVMBnuWJ aZARdAi7M2rDAvCDiiwj1KZhEoNs2TBtydJZlVwQ= Date: Wed, 9 Sep 2020 18:20:02 +0200 From: Jehan-Guillaume de Rorthais To: Peter Eisentraut Cc: pgsql-bugs@lists.postgresql.org, Daniel Verite , Thomas Munro , Peter Geoghegan , Tom Lane Subject: Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows Message-ID: <20200909182002.6995b685@firost> In-Reply-To: <995dfda3-344c-8c1a-2397-1bdf54dcbb4f@2ndquadrant.com> References: <20200903105727.064665ce@firost> <20200907152739.0fd6a12a@firost> <995dfda3-344c-8c1a-2397-1bdf54dcbb4f@2ndquadrant.com> Organization: Dalibo MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="MP_/EQquuItqBXcAohs.u_uAo_w" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --MP_/EQquuItqBXcAohs.u_uAo_w Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline On Tue, 8 Sep 2020 16:36:23 +0200 Peter Eisentraut wrote: > On 2020-09-07 15:27, Jehan-Guillaume de Rorthais wrote: > > Please, find a patch in attachment. It removes the buggy collation from doc > > and adapt existing ones to keep an example of combination of rules. > > I agree with this patch in principle. But perhaps we could keep another > reordering example, maybe latin/greek? Please, find in attachment a patch implementing your suggestion. Regards, --MP_/EQquuItqBXcAohs.u_uAo_w Content-Type: text/x-patch Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=v2-0001-doc-remove-buggy-ICU-collation-from-documentation.patch