[CALCITE-5827] Add IS_INF and IS_NAN functions (enabled in BigQuery library)

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.36.0
• Labels: pull-request-available
• Assignee: Tanner Clary
• Reporter: Tanner Clary
• Created: 10/Jul/23 06:02
• Updated: 10/Nov/23 11:34
• Resolved: 08/Aug/23 14:14

Description

BigQuery offers the IS_INF and IS_NAN functions. The first returns whether the specified value is infinite, the second returns whether the specified value is NaN.

Example 1: SELECT IS_INF(3) would return FALSE.
Example 2: SELECT IS_INF(CAST('Infinity` AS DOUBLE)) would return TRUE.
Example 3: SELECT IS_NAN(3) would return FALSE.
Example 4: SELECT IS_INF(CAST('NaN' AS DOUBLE)) would return TRUE.

Issue Links

• is related to: CALCITE-4589 'Infinity' float values fails with java.lang.ClassCastException
• is related to: CALCITE-2067 RexLiteral cannot represent accurately floating point values, including NaN, Infinity
• links to: GitHub Pull Request #3303