Re: 8.4b2 tsearch2 strange error
| От | Tom Lane |
|---|---|
| Тема | Re: 8.4b2 tsearch2 strange error |
| Дата | |
| Msg-id | 9436.1244054652@sss.pgh.pa.us обсуждение |
| Ответ на | Re: 8.4b2 tsearch2 strange error (Tatsuo Ishii <ishii@postgresql.org>) |
| Ответы |
Re: 8.4b2 tsearch2 strange error
|
| Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: