[BEAM-9708] count with no elements returns no value instead of 0

• Type: Bug
• Status: Resolved
• Priority: P4
• Resolution: Duplicate
• Fix Version/s: Missing
• Component/s: dsl-sql-zetasql
• Labels: zetasql-compliance
• Assignee: Unassigned
• Reporter: Andrew Pilloud
• Created: 06/Apr/20 23:08
• Updated: 13/Jan/22 21:52
• Resolved: 22/Jul/21 00:10

Description

two failures in shard 3, One failure in shard 37

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 {[]} 

[prepare_database]
CREATE TABLE TableEmpty AS SELECT val FROM (SELECT 1 as val) WHERE false
--
ARRAY<STRUCT<val INT64>>[]
==
[name=aggregation_count_6]
SELECT COUNT(*) FROM TableEmpty
--
ARRAY<STRUCT<INT64>>[{0}]
==
[name=aggregation_count_7]
SELECT COUNT(val) FROM TableEmpty
--
ARRAY<STRUCT<INT64>>[{0}]

SELECT COUNT(a) FROM (
SELECT a FROM (SELECT 1 a UNION ALL SELECT 2 UNION ALL SELECT 3) LIMIT 0 OFFSET 0)

Issue Links

• is duplicated by: BEAM-7123 COUNT(*) should return 0 when input is empty