blob: 3ab1dbc7ebe902020577915a5eff14e5f1d88796 [file] [log] [blame]
-- @Description Ensures that an update 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>: UPDATE ao SET b=1 WHERE a > 0;COMMIT;
2: VACUUM ao;
1<:
1: SELECT COUNT(*) FROM ao;
3: INSERT INTO ao VALUES (0);