1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
# name: test/sql/table_function/duckdb_settings.test
# description: Test duckdb_settings function
# group: [table_function]
statement ok
SET default_null_order='nulls_first';
statement ok
SELECT * FROM duckdb_settings();
query II
SELECT name, value FROM duckdb_settings() WHERE name='default_null_order';
----
default_null_order NULLS_FIRST
statement ok
SET default_null_order='nulls_last'
query II
SELECT name, value FROM duckdb_settings() WHERE name='default_null_order';
----
default_null_order NULLS_LAST
|
