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
|
# name: test/sql/storage/compact_block_size/ensure_bitpacking.test
# description: Ensure that we serialize a bitpacking segment for 256KB databases.
# group: [compact_block_size]
statement ok
SET threads=1;
statement ok
PRAGMA wal_autocheckpoint='1TB';
statement ok
ATTACH '__TEST_DIR__/smaller_block_size.db' (BLOCK_SIZE 16384);
statement ok
CREATE TABLE smaller_block_size.tbl AS SELECT range AS i FROM range(10000);
statement ok
ATTACH '__TEST_DIR__/larger_block_size.db' (BLOCK_SIZE 262144);
statement ok
CREATE TABLE larger_block_size.tbl AS SELECT range AS i FROM range(10000);
statement ok
CHECKPOINT smaller_block_size;
statement ok
CHECKPOINT larger_block_size;
query I
SELECT COUNT(*) > 0 FROM pragma_storage_info('larger_block_size.tbl') WHERE compression = 'BitPacking';
----
1
|
