SET DATESTYLE=ISO;
--
-- Test: undo testing
--
-- case 1: simple undo testing
CREATE TABLE cmpr_rollback ( 
	RES_ID varchar(255) NOT NULL,
	NE_ID int NOT NULL,
	COLLECT_TIME timestamp(1) WITHOUT TIME ZONE NOT NULL,
	INSERT_TIME timestamp(1) WITHOUT TIME ZONE NOT NULL,
	IS_VALID int NOT NULL,
	I3599 float NULL,
	I3600 float NULL,
	I3601 numeric(23,2) NULL,
	I3602 numeric(23,0) NULL,
	I3603 float NULL
) ;
SELECT COUNT(*) FROM cmpr_rollback;
SELECT * FROM cmpr_rollback;
START TRANSACTION;
COPY cmpr_rollback FROM '@abs_srcdir@/data/cmpr_common.data';
ROLLBACK TRANSACTION;
SELECT COUNT(*) FROM cmpr_rollback;
SELECT * FROM cmpr_rollback;
DROP TABLE cmpr_rollback;

CREATE TABLE cmpr_rollback_raw ( 
	RES_ID varchar(255) NOT NULL,
	NE_ID int NOT NULL,
	COLLECT_TIME timestamp(1) WITHOUT TIME ZONE NOT NULL,
	INSERT_TIME timestamp(1) WITHOUT TIME ZONE NOT NULL,
	IS_VALID int NOT NULL,
	I3599 float NULL,
	I3600 float NULL,
	I3601 numeric(23,2) NULL,
	I3602 numeric(23,0) NULL,
	I3603 float NULL
);
SELECT COUNT(*) FROM cmpr_rollback_raw;
SELECT * FROM cmpr_rollback_raw;
START TRANSACTION;
COPY cmpr_rollback_raw FROM '@abs_srcdir@/data/cmpr_common.data';
ROLLBACK TRANSACTION;
SELECT COUNT(*) FROM cmpr_rollback_raw;
SELECT * FROM cmpr_rollback_raw;
DROP TABLE cmpr_rollback_raw;