| 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: | Whole Thread | Raw Message | 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 |