--
-- TEST CASE: all branchs for Number String Compression
--
CREATE TABLE cmpr_numstr_02
(
	a00 varchar(2000) NUMSTR,
	a01 varchar(2000) NUMSTR,
	a02 varchar(2000) NUMSTR,
	a03 varchar(2000) NUMSTR,
	a04 varchar(2000) NUMSTR,
	a05 varchar(2000) NUMSTR,
	a06 varchar(2000) NUMSTR,
	a07 varchar(2000) NUMSTR,
	a08 varchar(2000) NUMSTR,
	a09 varchar(2000) NUMSTR,
	a10 varchar(2000) NUMSTR,
	a11 varchar(2000) NUMSTR,
	a12 varchar(2000) NUMSTR,
	a13 varchar(2000) NUMSTR,
	a15 varchar(2000) NUMSTR
) ;
COPY cmpr_numstr_02 FROM '@abs_srcdir@/data/cmpr_numstr_01.data';
CREATE TABLE cmpr_numstr_01 (
	a00 varchar(2000) NUMSTR,
	a01 varchar(2000) NUMSTR,
	a02 varchar(2000) NUMSTR,
	a03 varchar(2000) NUMSTR,
	a04 varchar(2000) NUMSTR,
	a05 varchar(2000) NUMSTR,
	a06 varchar(2000) NUMSTR,
	a07 varchar(2000) NUMSTR,
	a08 varchar(2000) NUMSTR,
	a09 varchar(2000) NUMSTR,
	a10 varchar(2000) NUMSTR,
	a11 varchar(2000) NUMSTR,
	a12 varchar(2000) NUMSTR,
	a13 varchar(2000) NUMSTR,
	a15 varchar(2000) NUMSTR
);
COPY cmpr_numstr_01 FROM '@abs_srcdir@/data/cmpr_numstr_01.data';
SELECT (SELECT COUNT(*) FROM cmpr_numstr_02) - (SELECT COUNT(*) FROM cmpr_numstr_01);
 ?column? 
----------
        0
(1 row)

(SELECT * FROM cmpr_numstr_02) MINUS ALL (SELECT * FROM cmpr_numstr_01);
 a00 | a01 | a02 | a03 | a04 | a05 | a06 | a07 | a08 | a09 | a10 | a11 | a12 | a13 | a15 
-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----
(0 rows)

(SELECT * FROM cmpr_numstr_01) MINUS ALL (SELECT * FROM cmpr_numstr_02);
 a00 | a01 | a02 | a03 | a04 | a05 | a06 | a07 | a08 | a09 | a10 | a11 | a12 | a13 | a15 
-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----
(0 rows)

DROP TABLE cmpr_numstr_02;
DROP TABLE cmpr_numstr_01;