Обсуждение: backend crashes deterministically

Marinos Yannikos (mjy@geizhals.at) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
backend crashes deterministically

Long Description
With the postgresql-7.0.3 port for FreeBSD, using FreeBSD 4.1.1-STABLE, the following query kills the backend:

select m.topic_id,m.message_id,m.message_author,
t.topic_subject,m.message_subject,m.message_timestamp::date
from forum_messages m, forum_topics t where t.topic_id=m.topic_id
and (( lower(m.message_body) like '%ecotec%')
or ( lower(m.message_subject) like '%ecotec%')
or (lower(m.message_author) like '%ecotec%'))
order by topic_id asc;

Without "order by topic_id asc", the query works without problems. Also, it works with most other search strings I
tried.

Database schema available on request. Since this is data-dependent, I have a copy (dump) of the database as well.



Sample Code


No file was uploaded with this report

Marinos Yannikos (mjy@geizhals.at) writes:
> Database schema available on request. Since this is data-dependent, I
> have a copy (dump) of the database as well.

Please.  A stack trace from the crashed backend would be nice too.

            regards, tom lane