blob: 72805a43202c5575ceade30fd2173ab21cf63711 [file] [log] [blame]
-- @Description Ensures that a delete before a vacuum operation is ok
--
DROP TABLE IF EXISTS ao;
CREATE TABLE ao (a INT, b INT) USING @amname@;
INSERT INTO ao SELECT i as a, i as b FROM generate_series(1, 100) AS i;
DELETE FROM ao WHERE a < 12;
1: BEGIN;
1: SELECT COUNT(*) FROM ao;
1>: DELETE FROM ao WHERE a < 90;COMMIT;
2: VACUUM ao;
1<:
1: SELECT COUNT(*) FROM ao;
3: INSERT INTO ao VALUES (0);