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
|
# name: test/sql/attach/attach_wal_alter_sequence.test
# description: Test binding of a WAL with a sequence entry in it
# group: [attach]
statement ok
PRAGMA disable_checkpoint_on_shutdown
statement ok
PRAGMA wal_autocheckpoint='1TB';
# create a table with hugeints
statement ok
attach '__TEST_DIR__/attach_wal_with_sequence.db' as db1;
statement ok
CREATE SEQUENCE db1.seq;
statement ok
CREATE TABLE db1.test (a INTEGER DEFAULT nextval('seq'), b INTEGER, c INTEGER DEFAULT currval('seq'));
statement ok
INSERT INTO db1.test (b) VALUES (1);
statement ok
alter table db1.test RENAME TO blubb;
statement ok
INSERT INTO db1.blubb (b) VALUES (10);
query III
SELECT * FROM db1.blubb
----
1 1 1
2 10 2
statement ok
DETACH db1
statement ok
attach '__TEST_DIR__/attach_wal_with_sequence.db' as db2;
statement ok
INSERT INTO db2.blubb (b) VALUES (100);
query III
SELECT * FROM db2.blubb
----
1 1 1
2 10 2
3 100 3
|
