src/test/regress/sql/uaocs_compaction/eof_truncate.sql

-- @Description Tests the behavior while compacting is disabled
CREATE TABLE uaocs_eof_truncate (a INT, b INT, c CHAR(128)) WITH (appendonly=true, orientation=column);
CREATE INDEX uaocs_eof_truncate_index ON uaocs_eof_truncate(b);
BEGIN;
INSERT INTO uaocs_eof_truncate SELECT i as a, 1 as b, 'hello world' as c FROM generate_series(1,1000) AS i;
ANALYZE uaocs_eof_truncate;
COMMIT;
BEGIN;
INSERT INTO uaocs_eof_truncate SELECT i as a, 1 as b, 'hello world' as c FROM generate_series(1000,2000) AS i;
ROLLBACK;

SET gp_appendonly_compaction=false;
SELECT COUNT(*) FROM uaocs_eof_truncate;
VACUUM uaocs_eof_truncate;
SELECT COUNT(*) FROM uaocs_eof_truncate;
-- Insert afterwards
INSERT INTO uaocs_eof_truncate SELECT i as a, 1 as b, 'hello world' as c FROM generate_series(1,10) AS i;
SELECT COUNT(*) FROM uaocs_eof_truncate;