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
|
# name: test/sql/attach/attach_dbname_quotes.test
# description: Test ATTACH with a quoted database name
# group: [attach]
statement ok
ATTACH ':memory:' as "my""db";
statement ok
CREATE TABLE "my""db".tbl(i int);
statement ok
INSERT INTO "my""db".tbl VALUES (42)
# use with a table name in quotes
statement ok
USE "my""db";
statement ok
SET search_path=current_setting('search_path')
query I
SELECT * FROM tbl
----
42
statement ok
ATTACH '__TEST_DIR__/attach_quoated_base.db'
statement ok
USE attach_quoated_base
statement ok
CREATE SCHEMA "my""db"."my""schema"
statement ok
CREATE TABLE "my""db"."my""schema".tbl(i int);
statement ok
INSERT INTO "my""db"."my""schema".tbl VALUES (84)
statement ok
USE "my""db"."my""schema"
query I
SELECT * FROM tbl
----
84
statement ok
CREATE SCHEMA """"
statement ok
USE """"
|
