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
|
# name: test/sql/settings/setting_preserve_identifier_case.test
# description: Test preserve_identifier_case setting
# group: [settings]
query I
SELECT value FROM duckdb_settings() WHERE name='preserve_identifier_case'
----
true
statement ok
CREATE SCHEMA MYSCHEMA;
statement ok
CREATE TABLE MYSCHEMA.INTEGERS(I INTEGER);
query III
SELECT duckdb_tables.schema_name, duckdb_tables.table_name, column_name FROM duckdb_tables JOIN duckdb_columns USING (table_oid);
----
MYSCHEMA INTEGERS I
statement ok
DROP SCHEMA MYSCHEMA CASCADE
statement ok
SET preserve_identifier_case TO false;
query I
SELECT value FROM duckdb_settings() WHERE name='preserve_identifier_case'
----
false
statement ok
CREATE SCHEMA MYSCHEMA;
statement ok
CREATE TABLE MYSCHEMA.INTEGERS(I INTEGER);
query III
SELECT duckdb_tables.schema_name, duckdb_tables.table_name, column_name FROM duckdb_tables JOIN duckdb_columns USING (table_oid);
----
myschema integers i
|
