Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-5827

Add IS_INF and IS_NAN functions (enabled in BigQuery library)

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.36.0
    • None

    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.

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-4589 'Infinity' float values fails with java.lang.ClassCastException

          • Blocker - Blocks development and/or testing work, production could not run
          • Open

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-2067 RexLiteral cannot represent accurately floating point values, including NaN, Infinity

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link GitHub Pull Request #3303

          Activity

            People

              tanclary Tanner Clary
              tanclary Tanner Clary
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: