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
|
# name: test/sql/attach/attach_issue_7660.test
# description: Issue #7660 - USE databases causes export database to produce duplicate data
# group: [attach]
statement ok
attach ':memory:' as test;
statement ok
use test;
statement ok
create table tbl1 as select 1 as a;
query I
FROM test.tbl1
----
1
statement ok
export database '__TEST_DIR__/test_issue_7660';
statement ok
USE memory
statement ok
DETACH test
statement ok
import database '__TEST_DIR__/test_issue_7660'
query I
FROM tbl1
----
1
|