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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
# name: test/issues/general/test_5072.test
# description: Issue 5072: CARDINALITY on NULL map results in non-deterministic result
# group: [general]
statement ok
PRAGMA enable_verification
query I
SELECT CARDINALITY(CAST(NULL AS MAP(VARCHAR, INT)));
----
NULL
query I
WITH src AS ( VALUES (1, NULL) )
SELECT CARDINALITY(HISTOGRAM(val)) FROM src AS t(k, val);
----
NULL
statement error
CREATE TABLE t1 AS (SELECT ARRAY[(1, 'x'), (2, 'y'), (4, 's')] AS list);
----
Invalid Input Error: A table cannot be created from an unnamed struct
statement ok
CREATE TABLE t1 (list STRUCT(a INT, b VARCHAR)[]);
statement ok
INSERT INTO t1 VALUES (ARRAY[(1, 'x'), (2, 'y'), (4, 's')]);
statement ok
INSERT INTO t1 VALUES (ARRAY[(2, 'a'), (3,'b')]);
statement ok
INSERT INTO t1 VALUES (NULL);
statement ok
INSERT INTO t1 VALUES (ARRAY[(5, NULL), (2, 'T')]);
query I
SELECT MAP_FROM_ENTRIES(list) FROM t1;
----
{1=x, 2=y, 4=s}
{2=a, 3=b}
NULL
{5=NULL, 2=T}
query I
SELECT CARDINALITY(MAP_FROM_ENTRIES(list)) FROM t1;
----
3
2
NULL
2
statement ok
INSERT INTO t1 VALUES (ARRAY[(7,'g'), (NULL, 'Y')]);
statement error
SELECT CARDINALITY(MAP_FROM_ENTRIES(list)) FROM t1;
----
Invalid Input Error: Map keys can not be NULL
|
