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
|
# name: test/sql/storage/compression/dictionary/dictionary_storage_info.test
# description: Test storage with Dictionary compression
# group: [dictionary]
require no_latest_storage
# load the DB from disk
load __TEST_DIR__/test_dictionary.db readwrite v1.0.0
statement ok
PRAGMA force_compression = 'dictionary'
statement ok
CREATE TABLE test (a VARCHAR, b VARCHAR);
statement ok
INSERT INTO test VALUES ('11', '22'), ('11', '22'), ('12', '21'), (NULL, NULL)
statement ok
CHECKPOINT
query I
SELECT compression FROM pragma_storage_info('test') WHERE segment_type ILIKE 'VARCHAR' LIMIT 1
----
Dictionary
|
