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/storage/concurrent_attach.test_slow
# description: Test concurrent attaching
# group: [storage]
concurrentforeach name foo bar
statement ok
attach '__TEST_DIR__/${name}.duckdb' AS ${name}
statement ok
create table ${name}.${name}(${name} bigint)
loop i 0 1000
statement ok
insert into ${name}.${name} select sum(i) from range((random()*1000000.0)::INT) r(i)
statement ok
checkpoint ${name}
statement ok
detach ${name}
statement ok
attach '__TEST_DIR__/${name}.duckdb' AS ${name}
endloop
query I
select count(*) FROM ${name}.${name}
----
1000
endloop
|