aboutsummaryrefslogblamecommitdiff
path: root/sql/core/src/test/resources/sql-tests/inputs/null-propagation.sql
blob: 66549da7971d3004dc12098b14d339cde620d6e9 (plain) (tree)
1
2
3
4
5
6
7
8
9








                                                   
-- count(null) should be 0
SELECT COUNT(NULL) FROM VALUES 1, 2, 3;
SELECT COUNT(1 + NULL) FROM VALUES 1, 2, 3;

-- count(null) on window should be 0
SELECT COUNT(NULL) OVER () FROM VALUES 1, 2, 3;
SELECT COUNT(1 + NULL) OVER () FROM VALUES 1, 2, 3;