[
https://issues.apache.org/jira/browse/BEAM-9708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrew Pilloud updated BEAM-9708:
-
Description:
two failures in shard 3, One failure in shard 37
{code:java}
Expected: ARRAY>[{0}]
Actual: ARRAY>[],
Details: Number of array elements is {1} and {0} in respective arrays
{[unordered: {0}]} and {[]} {code}
{code}
[prepare_database]
CREATE TABLE TableEmpty AS SELECT val FROM (SELECT 1 as val) WHERE false
--
ARRAY>[]
==
[name=aggregation_count_6]
SELECT COUNT(*) FROM TableEmpty
--
ARRAY>[{0}]
==
[name=aggregation_count_7]
SELECT COUNT(val) FROM TableEmpty
--
ARRAY>[{0}]
{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}
was:
One failure in shard 37
{code:java}
Expected: ARRAY>[{0}]
Actual: ARRAY>[],
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}
> 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
>
> two failures in shard 3, One failure in shard 37
> {code:java}
> Expected: ARRAY>[{0}]
> Actual: ARRAY>[],
> Details: Number of array elements is {1} and {0} in respective arrays
> {[unordered: {0}]} and {[]} {code}
> {code}
> [prepare_database]
> CREATE TABLE TableEmpty AS SELECT val FROM (SELECT 1 as val) WHERE false
> --
> ARRAY>[]
> ==
> [name=aggregation_count_6]
> SELECT COUNT(*) FROM TableEmpty
> --
> ARRAY>[{0}]
> ==
> [name=aggregation_count_7]
> SELECT COUNT(val) FROM TableEmpty
> --
> ARRAY>[{0}]
> {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)
