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)