[
https://issues.apache.org/jira/browse/DERBY-3290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12553363
]
Knut Anders Hatlen commented on DERBY-3290:
-------------------------------------------
Not sure how NaN would be affected by maximum and minimum numbers
supported, since it's not a number... ;)
The syntax rules you mentioned in chapter 6.1 say that FLOAT, REAL and
DOUBLE PRECISION are approximate numeric. Chapter 4.4.2 says that "[an]
approximate numeric value consists of a mantissa and an exponent. The
mantissa is a signed numeric value, and the exponent is a signed integer
that specifies the magnitude of the mantissa. (...) The value of an
approximate numeric value is the mantissa multiplied by a factor
determined by the exponent." I'm not sure this allows representation of
NaN or infinity.
> Derby cannot store java Double or Float values .NaN and
> .[POSITIVE|NEGATIVE]_INFINITY
> -------------------------------------------------------------------------------------
>
> Key: DERBY-3290
> URL: https://issues.apache.org/jira/browse/DERBY-3290
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Reporter: Thomas Nielsen
> Priority: Minor
> Attachments: TestNaN.java
>
>
> Issue originally reported on derby-user, where user cannot store .NaN or
> .INFINITE for java datatypes Double or Float.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
