[jira] [Created] (CALCITE-5827) Add TO_HEX and FROM_HEX functions (enabled in BigQuery library)

["Tanner Clary (Jira)" <ji...@apache.org>]

Tanner Clary created CALCITE-5827:
-------------------------------------

             Summary: Add TO_HEX and FROM_HEX functions (enabled in BigQuery library)
                 Key: CALCITE-5827
                 URL: https://issues.apache.org/jira/browse/CALCITE-5827
             Project: Calcite
          Issue Type: New Feature
            Reporter: Tanner Clary
            Assignee: Tanner Clary


BigQuery offers the [IS_INF|https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#is_inf] and [IS_NAN|https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#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`.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)