[CALCITE-2067] RexLiteral cannot represent accurately floating point values, including NaN, Infinity

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.13.0
• Fix Version/s: 1.37.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Volodymyr Tkach
• Created: 27/Nov/17 20:40
• Updated: 1 week ago 22:54

Description

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.

Issue Links

• relates to: CALCITE-6052 SqlImplementor writes REAL, FLOAT, or DOUBLE literals as DECIMAL literals
• relates to: CALCITE-5827 Add IS_INF and IS_NAN functions (enabled in BigQuery library)
• links to: GitHub Pull Request #572
• links to: GitHub Pull Request #3663
• links to: Pull request