From: | pgsql-bugs(at)postgresql(dot)org |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | backend crashes deterministically |
Date: | 2001-03-02 19:13:28 |
Message-ID: | 200103021913.f22JDSi05864@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Marinos Yannikos (mjy(at)geizhals(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2001-03-02 23:24:22 | polygon insert into r-tree sometimes fails |
Previous Message | Peter Eisentraut | 2001-03-02 17:08:44 | Re: Installation bug |