Tatsuo Ishii <ishii@postgresql.org> writes:
> STATEMENT: SELECT msg_sid, hdr_from, hdr_to, hdr_subject, msg_date, folder_id, msgnum FROM msginfo LEFT JOIN
msg_folderinfoUSING (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: -50
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.
I'm still unable to reproduce the "tuple offset out of range" errors.
regards, tom lane