sql-tests/inputs/count.sql

0001 -- Test data.
0002 CREATE OR REPLACE TEMPORARY VIEW testData AS SELECT * FROM VALUES
0003 (1, 1), (1, 2), (2, 1), (1, 1), (null, 2), (1, null), (null, null)
0004 AS testData(a, b);
0005
0006 -- count with single expression
0007 SELECT
0008   count(*), count(1), count(null), count(a), count(b), count(a + b), count((a, b))
0009 FROM testData;
0010
0011 -- distinct count with single expression
0012 SELECT
0013   count(DISTINCT 1),
0014   count(DISTINCT null),
0015   count(DISTINCT a),
0016   count(DISTINCT b),
0017   count(DISTINCT (a + b)),
0018   count(DISTINCT (a, b))
0019 FROM testData;
0020
0021 -- count with multiple expressions
0022 SELECT count(a, b), count(b, a), count(testData.*) FROM testData;
0023
0024 -- distinct count with multiple expressions
0025 SELECT
0026   count(DISTINCT a, b), count(DISTINCT b, a), count(DISTINCT *), count(DISTINCT testData.*)
0027 FROM testData;