--
-- TEST CASE: FIXED LENGTH OF 6 BYTES
--
CREATE TABLE cmpr_6bytes_00 ( 
	RR_ID int,
	R0_ID MACADDR,
	R1_ID MACADDR,
	R2_ID MACADDR,
	R3_ID MACADDR,
	R4_ID MACADDR,
	R5_ID MACADDR,
	R6_ID MACADDR,
	R7_ID MACADDR,
	R8_ID MACADDR,
	R9_ID MACADDR,
	R10_ID MACADDR,
	R11_ID MACADDR,
	R12_ID MACADDR
); 
INSERT INTO cmpr_6bytes_00 SELECT generate_series(1, 5000), 
	'12:34:56:78:90:ab', '12:34:56:78:90:ab', '12:34:56:78:90:ab', '12:34:56:78:90:ab', '12:34:56:78:90:ab', '12:34:56:78:90:ab', '12:34:56:78:90:ab',
	'12:34:56:78:90:ab', '12:34:56:78:90:ab', '12:34:56:78:90:ab', '12:34:56:78:90:ab', '12:34:56:78:90:ab', '12:34:56:78:90:ab';
COPY cmpr_6bytes_00 TO '@abs_srcdir@/data/cmpr_6bytes.data';
CREATE TABLE cmpr_6bytes_01 (
	RR_ID int,
	R0_ID MACADDR,
	R1_ID MACADDR,
	R2_ID MACADDR,
	R3_ID MACADDR,
	R4_ID MACADDR,
	R5_ID MACADDR,
	R6_ID MACADDR,
	R7_ID MACADDR,
	R8_ID MACADDR,
	R9_ID MACADDR,
	R10_ID MACADDR,
	R11_ID MACADDR,
	R12_ID MACADDR
) ;
COPY cmpr_6bytes_01 FROM '@abs_srcdir@/data/cmpr_6bytes.data';
SELECT (SELECT COUNT(*) FROM cmpr_6bytes_00) - (SELECT COUNT(*) FROM cmpr_6bytes_01);
 ?column? 
----------
        0
(1 row)

(SELECT * FROM cmpr_6bytes_00) MINUS ALL (SELECT * FROM cmpr_6bytes_01);
 rr_id | r0_id | r1_id | r2_id | r3_id | r4_id | r5_id | r6_id | r7_id | r8_id | r9_id | r10_id | r11_id | r12_id 
-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------
(0 rows)

(SELECT * FROM cmpr_6bytes_01) MINUS ALL (SELECT * FROM cmpr_6bytes_00);
 rr_id | r0_id | r1_id | r2_id | r3_id | r4_id | r5_id | r6_id | r7_id | r8_id | r9_id | r10_id | r11_id | r12_id 
-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------
(0 rows)

DROP TABLE cmpr_6bytes_00;
DROP TABLE cmpr_6bytes_01;
\! rm @abs_srcdir@/data/cmpr_6bytes.data