Re: citext LIKE search bug

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Morris de Oryx <morrisdeoryx(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: citext LIKE search bug
Date: 2019-09-28 16:32:53
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

On Thu, Sep 19, 2019 at 12:19:34AM -0400, Tom Lane wrote:
> Morris de Oryx <morrisdeoryx(at)gmail(dot)com> writes:
> > I'm using citext fields, and am working through how to build indexes that
> > the planner recognizes. I found this paragraph in the PG 11 release notes:
> > "Allow creation of indexes that can be used by LIKE comparisons on citext
> > columns (Alexey Chernyshov)
> > To do this, the index must be created using the citext_pattern_ops operator
> > class."
> >
> > As far as I can tell, this doesn't work, or at least not in my case with an
> > expression index.
> Hm. I found the original submission in the archives [1], and Alexey
> explicitly *didn't* claim that that patch was sufficient to enable LIKE
> index optimizations on citext. Indeed it obviously isn't, since it just
> created some weirdly-named operators without connecting them up to the
> LIKE plumbing in any way. So this seems like a case of the REL11 release
> notes author (probably Bruce) not reading too closely, which doesn't seem
> like entirely his fault since the commit message was totally content-free
> about what the point of the patch was [2].

I have no idea how I would have generated any release note item with
that commit or the commit diff. I must have asked someone, but I don't
remember who. The item was in my initial version of the relesae notes,
so it was not added later. Sorry.

Bruce Momjian <bruce(at)momjian(dot)us>

+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Cramer 2019-09-30 00:45:36 Re: BUG #16028: JDBC currentSchema connection parameter not working for text search configuration
Previous Message Stephan Knauss 2019-09-28 07:44:53 Re: BUG #16024: segfault ip 0000560103865c60 error 4 in postgres