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
|
# name: test/sql/attach/attach_same_db.test
# description: Test attaching of the same database
# group: [attach]
require notwindows
statement ok
PRAGMA enable_verification
statement ok
ATTACH '__TEST_DIR__/attach_same_db.db' AS db1
statement error
ATTACH '__TEST_DIR__/attach_same_db.db' AS db2
----
# we can detach and attach in the same transaction
statement ok
BEGIN
statement ok
DETACH db1
statement ok
ATTACH '__TEST_DIR__/attach_same_db.db' AS db1
statement ok
COMMIT
|