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
|
# name: test/sql/storage/optimistic_write/optimistic_write_multi_statement.test_slow
# description: Test multiple appends across statements within the same transaction
# group: [optimistic_write]
load __TEST_DIR__/optimistic_write_multi_statement.db
statement ok
SET force_compression='uncompressed';
statement ok
CREATE TABLE main_tbl (v INT);
statement ok
BEGIN
foreach file_size 130815 68295 68490
statement ok
CREATE OR REPLACE TEMPORARY TABLE insert_tbl AS FROM range(${file_size});
statement ok
INSERT INTO main_tbl FROM insert_tbl;
endloop
statement ok
COMMIT
|