Re: 8.4b2 tsearch2 strange error

> > I found the cause of this one --- the new code for estimating the
> > selectivity of @@ was not guarding against the possibility that the
> > given TSQuery is empty, as it is in this example.
> 
> Shouldn't be this in regression test?
> 
> > I'm still unable to reproduce the "tuple offset out of range" errors.
> 
> Maybe this is due to the difference how the index is physically
> organized. I will uplaod physical database cluster.

Done.

http://sylpheed.sraoss.jp/tmp/searcherdb84.tar.bz2

$ psql -U hiro sylph
Pager usage is off.
psql (8.4beta2)
Type "help" for help.

sylph=# SELECT msg_sid, hdr_from, hdr_to, hdr_subject, msg_date, folder_id, msgnum FROM msginfo LEFT JOIN msg_folderinfo USING (msg_sid) WHERE plainto_tsquery(E'a') @@ body_index;
NOTICE:  text-search query contains only stop words or doesn't contain lexemes, ignored
ERROR:  unrecognized operator: 24
STATEMENT:  SELECT msg_sid, hdr_from, hdr_to, hdr_subject, msg_date, folder_id, msgnum FROM msginfo LEFT JOIN msg_folderinfo USING (msg_sid) WHERE plainto_tsquery(E'a') @@ body_index;
ERROR:  unrecognized operator: 24
sylph=# SELECT msg_sid, hdr_from, hdr_to, hdr_subject, msg_date, folder_id, msgnum FROM msginfo LEFT JOIN msg_folderinfo USING (msg_sid) WHERE plainto_tsquery(E'tsearch') @@ body_index;
ERROR:  tuple offset out of range: 609
STATEMENT:  SELECT msg_sid, hdr_from, hdr_to, hdr_subject, msg_date, folder_id, msgnum FROM msginfo LEFT JOIN msg_folderinfo USING (msg_sid) WHERE plainto_tsquery(E'tsearch') @@ body_index;
ERROR:  tuple offset out of range: 609
--
Tatsuo Ishii
SRA OSS, Inc. Japan