src/test/singlenode_regress/sql/uaocs_compaction/full_eof_truncate.sql

-- @Description Tests the behavior while compacting is disabled
CREATE TABLE uaocs_full_eof_truncate (a INT, b INT, c CHAR(128)) WITH (appendonly=true, orientation=column);
CREATE INDEX uaocs_full_eof_truncate_index ON uaocs_full_eof_truncate(b);
BEGIN;
INSERT INTO uaocs_full_eof_truncate SELECT i as a, 1 as b, 'hello world' as c FROM generate_series(1,1000) AS i;
ANALYZE uaocs_full_eof_truncate;
COMMIT;
BEGIN;
INSERT INTO uaocs_full_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_full_eof_truncate;
VACUUM FULL uaocs_full_eof_truncate;
SELECT COUNT(*) FROM uaocs_full_eof_truncate;
-- Insert afterwards
INSERT INTO uaocs_full_eof_truncate SELECT i as a, 1 as b, 'hello world' as c FROM generate_series(1,10) AS i;
SELECT COUNT(*) FROM uaocs_full_eof_truncate;