[
https://issues.apache.org/jira/browse/CALCITE-2067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16269046#comment-16269046
]
Volodymyr Tkach commented on CALCITE-2067:
------------------------------------------
Sorry, fixed.
The behavior is inconsistent when comparing these queries:
select sin(cast('NaN' as float)); -- fails with NumberFormatException
select sin(num_column) from some_table; -- Succeeds, even if num_column
contains NaN,Infinity doubles
In this [PR|https://github.com/apache/calcite/pull/572], I am currently working
on, I have overloaded RexBuilder#makeApproxLiteral to handle Double values as
well. Will it be appropriate?
> RexBuilder can't handle NaN,Infinity double constants
> -----------------------------------------------------
>
> Key: CALCITE-2067
> URL: https://issues.apache.org/jira/browse/CALCITE-2067
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.13.0
> Reporter: Volodymyr Tkach
> Assignee: Julian Hyde
>
> Currently we are working in Drill to allow support for Nan an Infinity values
> .
> When using such values with functions we see the NumberFormatException
> exception.
> Query example: _select sin(cast('NaN' as float))_
> RexBuilder#clean and other RexBuilder's methods use BigDecimal for handling
> Double values, that's why we get NumberFormatException for nan,inf values.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
