You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Volodymyr Tkach (JIRA)" <ji...@apache.org> on 2017/12/07 13:19:00 UTC

[jira] [Created] (DRILL-6018) Drill can't handle NaN, Infinity literals

Volodymyr Tkach created DRILL-6018:
--------------------------------------

             Summary: Drill can't handle NaN, Infinity literals
                 Key: DRILL-6018
                 URL: https://issues.apache.org/jira/browse/DRILL-6018
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Volodymyr Tkach
            Assignee: Volodymyr Tkach


Queries like:
select sin(cast('NaN' as double)) from (values(1))
select cast('Infinity' as double)+1 from (values(1))

end up with NumberFormatException, because Drill and Calcite use BigDecimal to handle double literals. As a solution we can add  special symbols NAN, POS_INF, NEG_INF which will represent not numeric literals.
Created [calcite jira | https://issues.apache.org/jira/browse/CALCITE-2067] for this functionality.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)