Re: to_char() dumps core - Mailing list pgsql-hackers

From Karel Zak
Subject Re: to_char() dumps core
Date
Msg-id Pine.LNX.3.96.1001020181233.13295A-100000@ara.zf.jcu.cz
Whole thread Raw
In response to to_char() dumps core  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
On Fri, 20 Oct 2000, Tatsuo Ishii wrote:

> 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?
In the 7.1devel it's correct, but here it's bug, IMHO it bear on changes
in the 7.1's fmgr, because code is same in both versions for this. On Monday, 
I try fix it for 7.0.3 
                    Karel
> 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.
> 



pgsql-hackers by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: Re: pg_dump docs
Next
From: Hannu Krosing
Date:
Subject: Re: Unable to access CVS server