You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2007/12/19 14:35:43 UTC

[jira] Commented: (DERBY-3290) Derby cannot store java Double or Float values .NaN and .[POSITIVE|NEGATIVE]_INFINITY

    [ 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.