BUG #6185: Segmentation fault with NULL string columns

From: "Isaac Jurado" <ijurado(at)econcept(dot)es>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6185: Segmentation fault with NULL string columns
Date: 2011-08-30 08:51:55
Message-ID: 201108300851.p7U8ptkf014277@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6185
Logged by: Isaac Jurado
Email address: ijurado(at)econcept(dot)es
PostgreSQL version: 8.4.8
Operating system: Ubuntu 10.04.03 LTS (x86_64)
Description: Segmentation fault with NULL string columns
Details:

Here's the script to make it fail:

CREATE DATABASE killme;
\c killme
CREATE FUNCTION to_ascii(bytea, name) RETURNS text AS 'to_ascii_encname'
LANGUAGE internal;
CREATE TABLE mytable (id INTEGER PRIMARY KEY, mytext TEXT);
INSERT INTO mytable (id, mytext) VALUES (1, '');
SELECT * FROM mytable WHERE to_ascii(convert_to(mytext, 'latin1'), 'latin1')
= to_ascii(convert_to('nicetry', 'latin1'), 'latin1');
UPDATE mytable SET mytext=NULL WHERE id=1;
SELECT * FROM mytable WHERE to_ascii(convert_to(mytext, 'latin1'), 'latin1')
= to_ascii(convert_to('nicetry', 'latin1'), 'latin1');

After the second query, the database server segfaults. Note that it only
fails for NULL values. The to_ascii/convert_to combination is a recipe for
diacritics elimination found on a PostgreSQL forum.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Lampa 2011-08-30 11:20:20 BUG #6186: out of memory while analyze
Previous Message Ding Yuan 2011-08-30 07:15:19 BUG #6184: Inconsistencies in log messages