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
|
# name: test/sql/alter/add_col/test_add_col_default_seq.test
# description: Test ALTER TABLE ADD COLUMN: ADD COLUMN with sequence as default value
# group: [add_col]
require skip_reload
statement ok
CREATE TABLE test(i INTEGER, j INTEGER)
statement ok
INSERT INTO test VALUES (1, 1), (2, 2)
statement ok
CREATE SEQUENCE seq
statement ok
ALTER TABLE test ADD COLUMN m INTEGER DEFAULT nextval('seq')
query III
SELECT * FROM test
----
1
1
1
2
2
2
statement ok
ALTER TABLE test ADD COLUMN n INTEGER DEFAULT currval('seq')
query IIII
SELECT * FROM test
----
1
1
1
2
2
2
2
2
|
