blob: ed3a651aa66149b35e60fc016f65364513cd5c73 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
-- 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
|
