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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.13.0
• Fix Version/s: 1.38.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Mihai Budiu
• Reporter: Volodymyr Tkach
• Created: 27/Nov/17 20:40
• Updated: 31/Oct/24 23:52
• Resolved: 17/Oct/24 22:41

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

• blocks: CALCITE-6582 Release Calcite 1.38.0
• causes: CALCITE-6617 TypeCoercion is not applied correctly to comparisons
• 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