Re: to_char() dumps core

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