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
|
# name: test/sql/catalog/test_querying_from_detached_catalog.test
# description: Test switching from detached catalog to another catalog
# group: [catalog]
statement ok con1
ATTACH ':memory:' AS db1;
statement ok con1
ATTACH ':memory:' AS db2;
statement ok con1
CREATE TABLE db2.tbl (i INTEGER, j INTEGER);
statement ok con1
INSERT INTO db2.tbl VALUES (1, 2), (3,4);
statement ok con1
USE db1;
query I con1
SELECT CURRENT_SETTING('search_path');
----
db1.main
statement ok con2
USE db2;
# drop catalog db1, which con1 is using
statement ok con2
DETACH db1;
# querying to an attached catalog should work (with non-fully qualified name)
query II con1
FROM db2.tbl;
----
1 2
3 4
# querying to an attached catalog should work (with fully qualified name)
query II con1
FROM db2.main.tbl;
----
1 2
3 4
# creating a new table in db2 works
statement ok con1
CREATE TABLE db2.tbl2 AS SELECT 42;
# error message should say that the table does not exist
statement error con1
FROM db2.non_existent_table;
----
Catalog Error: Table with name non_existent_table does not exist!
# querying within the detached catalog fails
statement error con1
SHOW TABLES;
----
Binder Error: Catalog "db1" does not exist!
# swithcing to another catalog should work
statement ok con1
USE db2;
query I con1
SELECT CURRENT_SETTING('search_path');
----
db2.main
|
