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
|
# name: test/sql/function/generic/constant_or_null.test
# description: Test constant or null
# group: [generic]
statement ok
PRAGMA enable_verification
query II
SELECT constant_or_null(1, NULL), constant_or_null(1, 10)
----
NULL 1
query I
SELECT constant_or_null(1, case when i%2=0 then null else i end) from range(5) tbl(i)
----
NULL
1
NULL
1
NULL
query I
SELECT constant_or_null(1, case when i%2=0 then null else i end, case when i%2=1 then null else i end) from range(5) tbl(i)
----
NULL
NULL
NULL
NULL
NULL
statement error
SELECT constant_or_null(1);
----
statement error
SELECT constant_or_null();
----
|
