db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <Kristian.Waa...@Sun.COM>
Subject Re: Derby support for COALESCE
Date Tue, 29 Aug 2006 15:12:42 GMT
Robert Enyedi wrote:
> 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 have updated this Jira with a little more information.

The problem seems to be fixed in trunk, but not in the latest snapshot.
I'll ask on the developer list if anyone remember having done some work 
in this area lately. We might be able to get the fix into 10.2.


> 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

View raw message