--
-- 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);
(SELECT * FROM cmpr_6bytes_00) MINUS ALL (SELECT * FROM cmpr_6bytes_01);
(SELECT * FROM cmpr_6bytes_01) MINUS ALL (SELECT * FROM cmpr_6bytes_00);

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