src/test/singlenode_isolation2/output/uao/select_before_vacuum.source

-- @Description Ensures that a select before a vacuum operation is ok
--
DROP TABLE IF EXISTS ao;
DROP
CREATE TABLE ao (a INT) USING @amname@;
CREATE
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000

DELETE FROM ao WHERE a < 128;
DELETE 2667
1: BEGIN;
BEGIN
1: SELECT COUNT(*) FROM ao;
 count 
-------
 18333 
(1 row)
1: SELECT * FROM locktest_master WHERE coalesce = 'ao';
 coalesce | mode            | locktype | node   
----------+-----------------+----------+--------
 ao       | AccessShareLock | relation | master 
(1 row)
1: SELECT * FROM locktest_segments WHERE coalesce = 'ao';
 coalesce | mode | locktype | node 
----------+------+----------+------
(0 rows)
2&: VACUUM FULL ao;  <waiting ...>
1: COMMIT;
COMMIT
2<:  <... completed>
VACUUM
1: SELECT COUNT(*) FROM ao;
 count 
-------
 18333 
(1 row)
3: INSERT INTO ao VALUES (0);
INSERT 1