to_char() dumps core

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: to_char() dumps core
Date: 2000-10-20 14:22:19
Message-ID: 20001020232219P.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

In 7.0.2

select to_char(sum(n),'999') from t1;

causes backend dump a core if n is a float/numeric ...data type AND if
sum(n) returns NULL. This seems due to a bad null pointer handling for
aruguments of pass-by-reference data types. I think just a simple
null pointer checking at very top of each function (for example
float4_to_char()) would solve the problem. Comments?

test=# create table t1(f float);
CREATE
test=# select to_char(sum(f),'999') from t1;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2000-10-20 14:42:36 is there a way to DROP foreign key constraint ?
Previous Message Thomas Lockhart 2000-10-20 14:21:06 Re: Re: pg_dump docs

Browse pgsql-patches by date

  From Date Subject
Next Message Karel Zak 2000-10-20 16:35:24 Re: to_char() dumps core
Previous Message Marko Kreen 2000-10-19 22:27:12 Re: contrib/pgcrypto