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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
# name: test/sql/settings/setting_exhaustive.test
# description: Exhaustive setting tests
# group: [settings]
# debug_window_mode
statement error
SET debug_window_mode='unknown';
----
<REGEX>:.*unrecognized value.*
# default_order
foreach default_order ASC DESC
statement ok
SET default_order='${default_order}';
statement ok
SELECT * FROM duckdb_settings();
endloop
statement error
SET default_order='unknown';
----
<REGEX>:Invalid Input Error.*Expected ASC or DESC.*
# enable_external_access
statement error
SET enable_external_access=true
----
<REGEX>:Invalid Input Error.*Cannot enable external access while database is running.*
# enable_profiling
statement ok
SET profile_output='__TEST_DIR__/profile_output.txt'
foreach enable_profiling json query_tree query_tree_optimizer
statement ok
SET enable_profiling='${enable_profiling}';
statement ok
SELECT * FROM duckdb_settings();
endloop
statement error
SET enable_profiling='unknown';
----
<REGEX>:Parser Error.*Unrecognized print format.*
# enable_progress_bar
statement ok
PRAGMA disable_print_progress_bar
statement ok
SET enable_progress_bar=true;
statement error
SET GLOBAL enable_progress_bar=true;
----
<REGEX>:Catalog Error.*cannot be set globally.*
# explain_output
foreach explain_output all optimized_only physical_only
statement ok
SET explain_output='${explain_output}';
statement ok
SELECT * FROM duckdb_settings();
endloop
statement error
SET explain_output='unknown';
----
<REGEX>:.*unrecognized value.*
|
