db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: java.sql.SQLDataException: The resulting value is outside the range for the data type DOUBLE.
Date Fri, 01 Feb 2008 14:55:23 GMT
Knut Anders Hatlen wrote:
> Hong Ji <hongcodes@gmail.com> writes:
> 
>> Thanks for the replies.
>>
>> It will definitely help if the Java  Double.MAX_VALUE and
>> Double.MIN_VALUEare supported in Derby.
>>
>> Any reason why the Double.MAX_VALUE/Double.MIN_VALE are different in Derby
>> and Java?
> 
> According to the comments in the code, this is a limitation that was
> introduced for compatibility with DB2. Being compatible with DB2 is no
> longer a requirement for Derby, so if it's not causing any backward
> compatibility issues and someone signs up for DERBY-3290, there's
> nothing stopping us from lifting the restriction.

DERBY-3290 is a different issue, that's for adding support for 
non-numeric values to DOUBLE such as Double.Nan, which is believed to be 
against the SQL standard. Extending the range to match the java range 
should be a separate issue.

Dan.


Mime
View raw message