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
|
# name: test/sql/storage/struct_default_entries.test_slow
# description: Test struct with many default entries
# group: [storage]
statement ok
CREATE TABLE test_table (
"id" VARCHAR,
"str" STRUCT(
a VARCHAR
)
);
statement ok
INSERT INTO test_table(
"id"
)
(
SELECT
"id",
FROM
range(2000000) t(id)
QUALIFY
ROW_NUMBER() OVER (
PARTITION BY id
) = 1
);
query IIII
SELECT COUNT(DISTINCT id), COUNT(*), COUNT("str"), COUNT("str".a) FROM test_table
----
2000000 2000000 0 0
|
