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)