path: root/sql/core/src/test/resources/sql-tests/results/null-propagation.sql.out

-- 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