--
-- Test: COPY TO
--
CREATE TABLE cmpr_copyto_int (
	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_copyto_int FROM '@abs_srcdir@/data/cmpr_int_raw.data';
COPY cmpr_copyto_int TO '@abs_srcdir@/data/cmpr_copyto_int.data';
CREATE TABLE cmpr_copyto_temp (
	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_copyto_temp FROM '@abs_srcdir@/data/cmpr_copyto_int.data';
SELECT (SELECT COUNT(*) FROM cmpr_copyto_temp) - (SELECT COUNT(*) FROM cmpr_copyto_int);
(SELECT * FROM cmpr_copyto_temp) MINUS ALL (SELECT * FROM cmpr_copyto_int);
(SELECT * FROM cmpr_copyto_int) MINUS ALL (SELECT * FROM cmpr_copyto_temp);
DROP TABLE cmpr_copyto_int;
DROP TABLE cmpr_copyto_temp;
\! rm '@abs_srcdir@/data/cmpr_copyto_int.data'

CREATE TABLE cmpr_copyto_numstr (
	RS_ID int,
	R0_ID varchar(30) numstr NOT NULL,
	R1_ID varchar(30) numstr NOT NULL,
	R2_ID varchar(30) numstr NOT NULL,
	R3_ID varchar(30) numstr NOT NULL,
	R4_ID varchar(30) numstr NOT NULL,
	R5_ID varchar(30) numstr NOT NULL,
	R6_ID varchar(30) numstr NOT NULL
)  ;
COPY cmpr_copyto_numstr FROM '@abs_srcdir@/data/cmpr_numstr.data';
COPY cmpr_copyto_numstr TO '@abs_srcdir@/data/cmpr_copyto_numstr.data';
CREATE TABLE cmpr_copyto_temp (
	RS_ID int,
	R0_ID varchar(30) numstr NOT NULL,
	R1_ID varchar(30) numstr NOT NULL,
	R2_ID varchar(30) numstr NOT NULL,
	R3_ID varchar(30) numstr NOT NULL,
	R4_ID varchar(30) numstr NOT NULL,
	R5_ID varchar(30) numstr NOT NULL,
	R6_ID varchar(30) numstr NOT NULL
);
COPY cmpr_copyto_temp FROM '@abs_srcdir@/data/cmpr_copyto_numstr.data';
SELECT (SELECT COUNT(*) FROM cmpr_copyto_temp) - (SELECT COUNT(*) FROM cmpr_copyto_numstr);
(SELECT * FROM cmpr_copyto_temp) MINUS ALL (SELECT * FROM cmpr_copyto_numstr);
(SELECT * FROM cmpr_copyto_numstr) MINUS ALL (SELECT * FROM cmpr_copyto_temp);
DROP TABLE cmpr_copyto_numstr;
DROP TABLE cmpr_copyto_temp;
\! rm '@abs_srcdir@/data/cmpr_copyto_numstr.data'

CREATE TABLE cmpr_copyto_datetime(
	RR_ID int,
	R0_ID timestamp(3) WITHOUT TIME ZONE dictionary NOT NULL,
	R1_ID timestamp(3) WITHOUT TIME ZONE delta NOT NULL,
	R2_ID timestamp(3) WITHOUT TIME ZONE NOT NULL,
	R3_ID timestamp(3) WITHOUT TIME ZONE dictionary NOT NULL,
	R4_ID timestamp(3) WITHOUT TIME ZONE delta NOT NULL,
	R5_ID timestamp(3) WITHOUT TIME ZONE NOT NULL,
	R6_ID timestamp(3) WITHOUT TIME ZONE dictionary NOT NULL,
	R7_ID timestamp(3) WITHOUT TIME ZONE delta NOT NULL,
	R8_ID timestamp(3) WITHOUT TIME ZONE NOT NULL,
	R9_ID timestamp(3) WITHOUT TIME ZONE dictionary NOT NULL,
	R10_ID timestamp(3) WITHOUT TIME ZONE delta NOT NULL,
	R11_ID timestamp(3) WITHOUT TIME ZONE NOT NULL,
	R12_ID timestamp(3) WITHOUT TIME ZONE dictionary NOT NULL
) ;
COPY cmpr_copyto_datetime FROM '@abs_srcdir@/data/cmpr_datetime.data';
COPY cmpr_copyto_datetime TO '@abs_srcdir@/data/cmpr_copyto_datetime.data';
CREATE TABLE cmpr_copyto_temp(
	RR_ID int,
	R0_ID timestamp(3) WITHOUT TIME ZONE dictionary NOT NULL,
	R1_ID timestamp(3) WITHOUT TIME ZONE delta NOT NULL,
	R2_ID timestamp(3) WITHOUT TIME ZONE NOT NULL,
	R3_ID timestamp(3) WITHOUT TIME ZONE dictionary NOT NULL,
	R4_ID timestamp(3) WITHOUT TIME ZONE delta NOT NULL,
	R5_ID timestamp(3) WITHOUT TIME ZONE NOT NULL,
	R6_ID timestamp(3) WITHOUT TIME ZONE dictionary NOT NULL,
	R7_ID timestamp(3) WITHOUT TIME ZONE delta NOT NULL,
	R8_ID timestamp(3) WITHOUT TIME ZONE NOT NULL,
	R9_ID timestamp(3) WITHOUT TIME ZONE dictionary NOT NULL,
	R10_ID timestamp(3) WITHOUT TIME ZONE delta NOT NULL,
	R11_ID timestamp(3) WITHOUT TIME ZONE NOT NULL,
	R12_ID timestamp(3) WITHOUT TIME ZONE dictionary NOT NULL
) ;
COPY cmpr_copyto_temp FROM '@abs_srcdir@/data/cmpr_copyto_datetime.data';
SELECT (SELECT COUNT(*) FROM cmpr_copyto_temp) - (SELECT COUNT(*) FROM cmpr_copyto_datetime);
(SELECT * FROM cmpr_copyto_temp) MINUS ALL (SELECT * FROM cmpr_copyto_datetime);
(SELECT * FROM cmpr_copyto_datetime) MINUS ALL (SELECT * FROM cmpr_copyto_temp);
DROP TABLE cmpr_copyto_datetime;
DROP TABLE cmpr_copyto_temp;
\! rm '@abs_srcdir@/data/cmpr_copyto_datetime.data'