From: | 026809r(at)dragon(dot)acadiau(dot)ca (Michael Richards) |
---|---|
To: | scrappy(at)hub(dot)org |
Subject: | PostgreSQL bug in UPPER |
Date: | 1998-03-10 22:04:52 |
Message-ID: | 199803102204.SAA10587@dragon.acadiau.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi:
Little bug causes postgres to die:
sc=> select count(*) from urlcont where (UPPER(url) LIKE '%APOLLO%');
Field| Value
-- RECORD 0 --
count| 1
(1 row)
sc=> select count(*) from urlcont where (UPPER(content) LIKE '%APOLLO%');
FATAL 1: palloc failure: memory exhausted
sc=> select count(*) from urlcont where (UPPER(url) LIKE '%APOLLO%');
Broken pipe
bash$ psql -x sc
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: sc
sc=> select count(*) from urlcont where (UPPER(url) LIKE '%APOLLO%');
Field| Value
-- RECORD 0 --
count| 1
(1 row)
sc-> \d urlcont
Table = urlcont
+----------------------------------+----------------------------------+-------+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+
| url | varchar() |
256 |
| pos | int4 |
4 |
| content | varchar() |
1024 |
+----------------------------------+----------------------------------+-------+
Also, I suppose I should get on the postgres mailing list. You prolly
already have this done, so if you have a procmail filter set up for the
list, could you please clip it out and send it to me?
thanks
-Mike
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-03-10 22:20:51 | Re: your mail |
Previous Message | Maurice Gittens | 1998-03-10 18:53:46 | Re: [HACKERS] newoid in invapi.c |