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
51
52
53
54
55
56
|
# name: test/sql/alter/alter_table_set_table_options.test
# description: Test ALTER TABLE SET table options
# group: [alter]
statement ok
CREATE TABLE tbl1(i INTEGER);
statement ok
set variable location='my/location/path';
statement error
ALTER TABLE tbl1 SET ('foo'='baz', 'buzz'='wizz');
----
<REGEX>:.*Not implemented Error: SET .*options.* is not supported for DuckDB tables.*
statement error
ALTER TABLE tbl1 SET (foo='baz', buzz='wizz');
----
<REGEX>:.*Not implemented Error: SET .*options.* is not supported for DuckDB tables.*
# works with Functions
statement error
ALTER TABLE tbl1 SET (foo=getvariable('location'));
----
<REGEX>:.*Not implemented Error: SET .*options.* is not supported for DuckDB tables.*
statement error
ALTER TABLE tbl1 RESET ('foo', 'buzz');
----
<REGEX>:.*Not implemented Error: RESET .*options.* is not supported for DuckDB tables.*
statement error
ALTER TABLE tbl1 RESET (foo, buzz);
----
<REGEX>:.*Not implemented Error: RESET .*options.* is not supported for DuckDB tables.*
# Error depends on PEG parser or PostgreSQL parser
statement error
ALTER TABLE tbl1 RESET ('foo'='baz', 'buzz'='wizz');
----
<REGEX>:(.*Parser Error.*"'baz'".*|.*Parser Error.* Reset option "foo" cannot set any value.*)
statement error
ALTER TABLE tbl1 RESET (foo='baz', buzz='wizz');
----
<REGEX>:(.*Parser Error.*"'baz'".*|.*Parser Error.* Reset option "foo" cannot set any value.*)
statement error
ALTER TABLE tbl1 RESET ();
----
<REGEX>:.*Parser Error.*syntax error.*
statement error
ALTER TABLE tbl1 SET ();
----
<REGEX>:.*Parser Error.*syntax error.*
|
