Re: Wrong Results from SP-GiST with Collations - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: Wrong Results from SP-GiST with Collations
Date
Msg-id CAH2-WzkTSwd=3SP+P2gHA4LzBm8Z1AhVpGWrB=gpS-EMWrg9vw@mail.gmail.com
Whole thread Raw
In response to Re: Wrong Results from SP-GiST with Collations  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Mon, Apr 16, 2018 at 12:55 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I'm not following --- varstr_cmp has no way to know that we only
> care about equality vs inequality.  Yes, it might give back an
> answer quickly when the strings are equal, but when they aren't,
> it has to decide which is greater.  In this case we don't care,
> so long as the search operator is "=".

That was the subtlety I was missing. I didn't understand what you
meant, but thought that the fast-path might be relevant. Clearly not.

-- 
Peter Geoghegan


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Wrong Results from SP-GiST with Collations
Next
From: Vitaly V. Voronov
Date:
Subject: Re: BUG #15144: *** glibc detected *** postgres: postgres smsconsole [local] SELECT: double free or corruption (!pre