-- test case: free dict by VACUUM
-- prepare data
\! awk -F'|' '{print "1|" $0}' @abs_srcdir@/data/lineitem.data > @abs_srcdir@/data/lineitem.tmp
CREATE TABLE cmpr_cluster_02
(
	L_HASHKEY     BIGINT NOT NULL
  , L_ORDERKEY    BIGINT NOT NULL
  , L_PARTKEY     BIGINT NOT NULL
  , L_SUPPKEY     BIGINT NOT NULL
  , L_LINENUMBER  BIGINT NOT NULL
  , L_QUANTITY    DECIMAL(15,2) NOT NULL
  , L_EXTENDEDPRICE  DECIMAL(15,2) NOT NULL
  , L_DISCOUNT    DECIMAL(15,2) NOT NULL
  , L_TAX         DECIMAL(15,2) NOT NULL
  , L_RETURNFLAG  CHAR(1) NOT NULL
  , L_LINESTATUS  CHAR(1) NOT NULL
  , L_SHIPDATE    DATE NOT NULL
  , L_COMMITDATE  DATE NOT NULL
  , L_RECEIPTDATE DATE NOT NULL
  , L_SHIPINSTRUCT CHAR(25) NOT NULL
  , L_SHIPMODE     CHAR(10) NOT NULL
  , L_COMMENT      VARCHAR(44) NOT NULL
) compress
distribute by hash(L_HASHKEY);
COPY cmpr_cluster_02 FROM '@abs_srcdir@/data/lineitem.tmp' DELIMITER '|';
DELETE FROM cmpr_cluster_02;
VACUUM cmpr_cluster_02;
VACUUM cmpr_cluster_02;
VACUUM cmpr_cluster_02;
VACUUM cmpr_cluster_02;
-- clean up
\! rm @abs_srcdir@/data/lineitem.tmp