db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Enyedi <robert.eny...@intland.com>
Subject Re: Derby support for COALESCE
Date Tue, 29 Aug 2006 14:10:04 GMT
I already found the answer to this here: 

The scenario in which I get a NullPointerException when using COALESCE 
has been reported here: http://issues.apache.org/jira/browse/DERBY-1774

I would appreciate any suggestions on how to avoid this bug.


Robert Enyedi wrote:
> Hi,
> How does Derby support the COALESCE function? While the reference 
> manual briefly mentions that this is a reserved word and there is 
> SQLSTATE 42610 related to it, it does not get into details. The 
> function seems to work but (in a certain scenario which I did not 
> identify yet) it produces a server side NullPointerException.
> The functionality of COALESCE(x1, x2, x3, ...) returns the first item 
> from the list which is not null.
> Is COALESCE supported in Derby or is there a well documented 
> alternative function which does the same thing?
> Regards,
> Robert

View raw message