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
64
65
66
67
68
69
70
71
72
73
74
75
|
# name: test/sql/storage/compression/compression_null.test_slow
# description: Test storage with compression and many null values
# group: [compression]
# load the DB from disk
load __TEST_DIR__/test_rle.db
foreach compression <compression>
statement ok
PRAGMA force_compression = '${compression}'
# single NULL value
statement ok
CREATE TABLE nulls(i INTEGER)
statement ok
INSERT INTO nulls VALUES (NULL)
query I
SELECT * FROM nulls
----
NULL
restart
query I
SELECT * FROM nulls
----
NULL
statement ok
DROP TABLE nulls
# many null values
statement ok
CREATE TABLE nulls(i INTEGER)
statement ok
INSERT INTO nulls SELECT NULL FROM range(70000)
query III
SELECT COUNT(*), COUNT(i), SUM(i) FROM nulls
----
70000 0 NULL
restart
query III
SELECT COUNT(*), COUNT(i), SUM(i) FROM nulls
----
70000 0 NULL
# mix with non-null values
statement ok
INSERT INTO nulls VALUES (1), (1), (1), (2), (2), (2)
query III
SELECT COUNT(*), COUNT(i), SUM(i) FROM nulls
----
70006 6 9
restart
query III
SELECT COUNT(*), COUNT(i), SUM(i) FROM nulls
----
70006 6 9
statement ok
DROP TABLE nulls
endloop
|
