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
79
80
81
82
83
84
85
86
87
88
89
90
91
|
# name: test/sql/storage/read_duckdb/read_duckdb_basic.test
# description: Test basic usage of read_duckdb
# group: [read_duckdb]
statement ok
ATTACH '__TEST_DIR__/read_duckdb_test.db'
statement ok
CREATE TABLE read_duckdb_test.my_tbl AS SELECT 42 i
# we cannot read a database that is already attached
statement error
SELECT * FROM read_duckdb('__TEST_DIR__/read_duckdb_test.db')
----
already attached by database
statement ok
DETACH read_duckdb_test
query I
SELECT * FROM read_duckdb('__TEST_DIR__/read_duckdb_test.db')
----
42
query I
SELECT COUNT(*) FROM duckdb_databases
----
1
# globbing
statement ok
ATTACH '__TEST_DIR__/read_duckdb_test2.db'
statement ok
CREATE TABLE read_duckdb_test2.other_tbl AS SELECT 100 i
statement ok
DETACH read_duckdb_test2
query I
SELECT * FROM read_duckdb('__TEST_DIR__/read_duckdb_test*.db')
----
42
100
# replacement scan
query I
SELECT * FROM '__TEST_DIR__/read_duckdb_test*.db'
----
42
100
# prepared statement
statement ok
PREPARE v1 AS FROM read_duckdb('__TEST_DIR__/read_duckdb_test*.db')
query I
EXECUTE v1
----
42
100
# multi-table
statement ok
ATTACH '__TEST_DIR__/read_duckdb_test.db'
statement ok
CREATE TABLE read_duckdb_test.my_tbl2 AS SELECT 84 j
statement ok
DETACH read_duckdb_test
statement error
SELECT * FROM read_duckdb('__TEST_DIR__/read_duckdb_test.db')
----
multiple tables
query I
SELECT * FROM read_duckdb('__TEST_DIR__/read_duckdb_test.db', table_name='my_tbl')
----
42
query I
SELECT * FROM read_duckdb('__TEST_DIR__/read_duckdb_test.db', table_name='my_tbl2')
----
84
statement error
SELECT * FROM read_duckdb('__TEST_DIR__/read_duckdb_test.db', table_name='my_tblx')
----
my_tbl2
|
