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
|
# name: test/sql/storage/compression/bitpacking/bitpacking_table_copy.test
# description: Tests a table copy on a table spanning multiple segments
# group: [bitpacking]
require tpch
# load the DB from disk
load __TEST_DIR__/test_bitpacking_struct_bug.db
foreach bitpacking_mode delta_for for constant_delta
statement ok
PRAGMA force_bitpacking_mode='${bitpacking_mode}'
statement ok
PRAGMA force_compression = 'bitpacking'
statement ok
CREATE TABLE test (a integer);
statement ok
INSERT INTO test SELECT i FROM range(0,150000) tbl(i);
statement ok
checkpoint
statement ok
CREATE TABLE test_2 AS SELECT a FROM test;
statement ok
checkpoint
query I
select sum(a) from test;
----
11249925000
query I
select sum(a) from test_2;
----
11249925000
statement ok
drop table test
statement ok
drop table test_2
endloop
|
