Re: [HACKERS] [GENERAL] Incorrect FTS result with GIN index

2010-07-29 Thread Oleg Bartunov
Tom, we're not able to work on this right now, so go ahead if you have time. I also wonder why did I get right result :) Just repeated the query: test=# select count(*) from search_tab where (to_tsvector('german', keywords ) @@ to_tsquery('german', 'ee:* dd:*')); count --- 123 (1

Re: [HACKERS] [GENERAL] Incorrect FTS result with GIN index

2010-07-29 Thread Tom Lane
Oleg Bartunov o...@sai.msu.su writes: I also wonder why did I get right result :) Just repeated the query: test=# select count(*) from search_tab where (to_tsvector('german', keywords ) @@ to_tsquery('german', 'ee:* dd:*')); count --- 123 (1 row) Yeah, that case works (though

Re: [HACKERS] [GENERAL] Incorrect FTS result with GIN index

2010-07-29 Thread Oleg Bartunov
On Thu, 29 Jul 2010, Tom Lane wrote: Oleg Bartunov o...@sai.msu.su writes: I also wonder why did I get right result :) Just repeated the query: test=# select count(*) from search_tab where (to_tsvector('german', keywords ) @@ to_tsquery('german', 'ee:* dd:*')); count --- 123 (1

Re: [HACKERS] [GENERAL] Incorrect FTS result with GIN index

2010-07-29 Thread Tom Lane
Oleg Bartunov o...@sai.msu.su writes: On Thu, 29 Jul 2010, Tom Lane wrote: Yeah, that case works (though I think it's unnecessarily slow). The one that gives the wrong answer is the equivalent form with two AND'ed @@ operators. hmm, that query works too :) There may be some platform

Re: [HACKERS] [GENERAL] Incorrect FTS result with GIN index

2010-07-28 Thread Tom Lane
Oleg Bartunov o...@sai.msu.su writes: you can download dump http://mira.sai.msu.su/~megera/tmp/search_tab.dump Hmm ... I'm not sure why you're failing to reproduce it, because it's falling over pretty easily for me. After poking at it for awhile, I am of the opinion that scanGetItem's handling