Re: Incorrect FTS query results with GIN index - Mailing list pgsql-general

From Vyacheslav Kalinin
Subject Re: Incorrect FTS query results with GIN index
Date
Msg-id 9b1af80e1001180428q5fd2bd6cqb84fd08e1af82d53@mail.gmail.com
Whole thread Raw
In response to Re: Incorrect FTS query results with GIN index  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: Incorrect FTS query results with GIN index  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-general
Great, thank you!
I assume this one goes into 8.4.3, right?

2010/1/18 Teodor Sigaev <teodor@sigaev.ru>
Basically, I started testing prefix matching in FTS and got into
troubles. Self-contained example follows:

Thank you, fixed. The reason was in incorrect optimization of GIN scan: GIN reuses scan result for equals key, but comparison of key didn't take into account a difference of scan's strategy.



--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                  WWW: http://www.sigaev.ru/

pgsql-general by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: Incorrect FTS query results with GIN index
Next
From: Teodor Sigaev
Date:
Subject: Re: Incorrect FTS query results with GIN index