You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@beam.apache.org by "Andrew Pilloud (Jira)" <ji...@apache.org> on 2020/04/06 23:09:00 UTC

[jira] [Created] (BEAM-9708) count with no elements returns no value instead of 0

Andrew Pilloud created BEAM-9708:
------------------------------------

             Summary: count with no elements returns no value instead of 0
                 Key: BEAM-9708
                 URL: https://issues.apache.org/jira/browse/BEAM-9708
             Project: Beam
          Issue Type: Bug
          Components: dsl-sql-zetasql
            Reporter: Andrew Pilloud


One failure in shard 37
{code:java}
Expected: ARRAY<STRUCT<INT64>>[{0}]
  Actual: ARRAY<STRUCT<$col1 INT64>>[], 
 Details: Number of array elements is {1} and {0} in respective arrays {[unordered: {0}]} and {[]} {code}
{code}
SELECT COUNT(a) FROM (
SELECT a FROM (SELECT 1 a UNION ALL SELECT 2 UNION ALL SELECT 3) LIMIT 0 OFFSET 0)
{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)