--
-- case 1: integer type
--
CREATE TABLE cmpr_int_raw (
	RS_ID int,
	R0_ID int NOT NULL,
	R1_ID int NOT NULL,
	R2_ID int NOT NULL,
	R3_ID int NOT NULL,
	R4_ID int NOT NULL,
	R5_ID int NOT NULL,
	R6_ID int NOT NULL,
	R7_ID int NOT NULL,
	R8_ID int NOT NULL,
	R9_ID int NOT NULL
);
COPY cmpr_int_raw FROM '@abs_srcdir@/data/cmpr_int_raw.data';
CREATE TABLE cmpr_int_auto (
	RS_ID int,
	R0_ID int NOT NULL,
	R1_ID int NOT NULL,
	R2_ID int NOT NULL,
	R3_ID int NOT NULL,
	R4_ID int NOT NULL,
	R5_ID int NOT NULL,
	R6_ID int NOT NULL,
	R7_ID int NOT NULL,
	R8_ID int NOT NULL,
	R9_ID int NOT NULL
)  ;
COPY cmpr_int_auto FROM '@abs_srcdir@/data/cmpr_int_raw.data';
SELECT (SELECT COUNT(*) FROM cmpr_int_raw) - (SELECT COUNT(*) FROM cmpr_int_auto);
 ?column? 
----------
        0
(1 row)

(SELECT * FROM cmpr_int_raw) MINUS ALL (SELECT * FROM cmpr_int_auto);
 rs_id | r0_id | r1_id | r2_id | r3_id | r4_id | r5_id | r6_id | r7_id | r8_id | r9_id 
-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------
(0 rows)

(SELECT * FROM cmpr_int_auto) MINUS ALL (SELECT * FROM cmpr_int_raw);
 rs_id | r0_id | r1_id | r2_id | r3_id | r4_id | r5_id | r6_id | r7_id | r8_id | r9_id 
-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------
(0 rows)

DROP TABLE cmpr_int_auto;
CREATE TABLE cmpr_int_dict (
	RS_ID int dictionary,
	R0_ID int dictionary NOT NULL,
	R1_ID int dictionary NOT NULL,
	R2_ID int dictionary NOT NULL,
	R3_ID int dictionary NOT NULL,
	R4_ID int dictionary NOT NULL,
	R5_ID int dictionary NOT NULL,
	R6_ID int dictionary NOT NULL,
	R7_ID int dictionary NOT NULL,
	R8_ID int dictionary NOT NULL,
	R9_ID int dictionary NOT NULL
)  ;
COPY cmpr_int_dict FROM '@abs_srcdir@/data/cmpr_int_raw.data';
SELECT (SELECT COUNT(*) FROM cmpr_int_raw) - (SELECT COUNT(*) FROM cmpr_int_dict);
 ?column? 
----------
        0
(1 row)

(SELECT * FROM cmpr_int_raw) MINUS ALL (SELECT * FROM cmpr_int_dict);
 rs_id | r0_id | r1_id | r2_id | r3_id | r4_id | r5_id | r6_id | r7_id | r8_id | r9_id 
-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------
(0 rows)

(SELECT * FROM cmpr_int_dict) MINUS ALL (SELECT * FROM cmpr_int_raw);
 rs_id | r0_id | r1_id | r2_id | r3_id | r4_id | r5_id | r6_id | r7_id | r8_id | r9_id 
-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------
(0 rows)

DROP TABLE cmpr_int_dict;
CREATE TABLE cmpr_int_delta (
	RS_ID int delta,
	R0_ID int delta NOT NULL,
	R1_ID int delta NOT NULL,
	R2_ID int delta NOT NULL,
	R3_ID int delta NOT NULL,
	R4_ID int delta NOT NULL,
	R5_ID int delta NOT NULL,
	R6_ID int delta NOT NULL,
	R7_ID int delta NOT NULL,
	R8_ID int delta NOT NULL,
	R9_ID int delta NOT NULL
)  ;
COPY cmpr_int_delta FROM '@abs_srcdir@/data/cmpr_int_raw.data';
SELECT (SELECT COUNT(*) FROM cmpr_int_raw) - (SELECT COUNT(*) FROM cmpr_int_delta);
 ?column? 
----------
        0
(1 row)

(SELECT * FROM cmpr_int_raw) MINUS ALL (SELECT * FROM cmpr_int_delta);
 rs_id | r0_id | r1_id | r2_id | r3_id | r4_id | r5_id | r6_id | r7_id | r8_id | r9_id 
-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------
(0 rows)

(SELECT * FROM cmpr_int_delta) MINUS ALL (SELECT * FROM cmpr_int_raw);
 rs_id | r0_id | r1_id | r2_id | r3_id | r4_id | r5_id | r6_id | r7_id | r8_id | r9_id 
-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------
(0 rows)

DROP TABLE cmpr_int_delta;