blob: ed3a651aa66149b35e60fc016f65364513cd5c73 (
plain) (
tree)
|
|
-- Automatically generated by SQLQueryTestSuite
-- Number of queries: 4
-- !query 0
SELECT COUNT(NULL) FROM VALUES 1, 2, 3
-- !query 0 schema
struct<count(NULL):bigint>
-- !query 0 output
0
-- !query 1
SELECT COUNT(1 + NULL) FROM VALUES 1, 2, 3
-- !query 1 schema
struct<count((1 + CAST(NULL AS INT))):bigint>
-- !query 1 output
0
-- !query 2
SELECT COUNT(NULL) OVER () FROM VALUES 1, 2, 3
-- !query 2 schema
struct<count(NULL) OVER (ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING):bigint>
-- !query 2 output
0
0
0
-- !query 3
SELECT COUNT(1 + NULL) OVER () FROM VALUES 1, 2, 3
-- !query 3 schema
struct<count((1 + CAST(NULL AS INT))) OVER (ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING):bigint>
-- !query 3 output
0
0
0
|