[ https://issues.apache.org/jira/browse/BEAM-9708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrew Pilloud updated BEAM-9708: --------------------------------- Labels: zetasql-compliance (was: ) > 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 > Priority: Trivial > Labels: zetasql-compliance > > 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)