Uploaded image for project: 'Beam'
  1. Beam
  2. BEAM-12098

COUNT([]) returns no output.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • P3
    • Resolution: Duplicate
    • None
    • Missing
    • dsl-sql-zetasql
    • None

    Description

      SELECT COUNT( x) FROM UNNEST([]) AS x

      should return 0, returns nothing.

      See https://github.com/apache/beam/pull/14392/commits/0357ffc4c17b2b756c7ab2b285202d3637c81f41

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. BEAM-9514 AssertionError type mismatch from AggregateScanConverter

          • P2 - Default priority. Will be triaged and planned according to community practices.
          • Resolved
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. BEAM-7123 COUNT(*) should return 0 when input is empty

          • P3 - Non-urgent bugs, features, and improvements
          • Open

          Activity

            People

              Unassigned Unassigned
              ibzib Kyle Weaver
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: