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: 
http://mail-archives.apache.org/mod_mbox/db-derby-dev/200508.mbox/%3C1495151979.1123569755774.JavaMail.jira@ajax.apache.org%3E

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.

Regards,
Robert

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
>


Mime
View raw message