PostgreSQL bug in UPPER
От | 026809r@dragon.acadiau.ca (Michael Richards) |
---|---|
Тема | PostgreSQL bug in UPPER |
Дата | |
Msg-id | 199803102204.SAA10587@dragon.acadiau.ca обсуждение исходный текст |
Список | 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
В списке pgsql-hackers по дате отправления: