src/test/singlenode_isolation2/input/uao/selectinsert_while_vacuum.source

-- @Description Ensures that an insert during a vacuum operation is ok
-- 
CREATE TABLE selectinsert_while_vacuum_@amname@ (a INT) USING @amname@;
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);
insert into selectinsert_while_vacuum_@amname@ select generate_series(1,1000);

DELETE FROM selectinsert_while_vacuum_@amname@ WHERE a < 128;
4: BEGIN;
4: SELECT COUNT(*) FROM selectinsert_while_vacuum_@amname@;
5: BEGIN;
4: SELECT COUNT(*) FROM selectinsert_while_vacuum_@amname@;
4: BEGIN;
4: SELECT COUNT(*) FROM selectinsert_while_vacuum_@amname@;
2>: VACUUM selectinsert_while_vacuum_@amname@;
4: SELECT COUNT(*) FROM selectinsert_while_vacuum_@amname@;SELECT COUNT(*) FROM selectinsert_while_vacuum_@amname@;BEGIN;insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);insert into selectinsert_while_vacuum_@amname@ select generate_series(1001,2000);COMMIT;
2<:
3: SELECT COUNT(*) FROM selectinsert_while_vacuum_@amname@ WHERE a = 1500;
3: INSERT INTO selectinsert_while_vacuum_@amname@ VALUES (0);