[
https://issues.apache.org/jira/browse/DERBY-3290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12553403
]
Daniel John Debrunner commented on DERBY-3290:
----------------------------------------------
Another issue would be backwards compatibility. Current Derby does perform the
role of ensuring only valid numeric values are allowed in DOUBLE/REAL columns
which (thanks to Knut Anders) does follow the SQL Standard.
Changing these datatypes to allow such values would be a change in behaviour
and a dangerous one for any application relying on the current behaviour.
> 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.
