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.
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 |
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 |