set enable_vector_engine=on;
SET DATESTYLE=ISO;
-- Problem:
-- basic DATE type data compression, including DELTA method, min/max computation.
CREATE TABLE colcmpr_date
(
	distkey INT4,
	a date,
	b date,
	c date
) with (orientation = column)  ;
COPY colcmpr_date FROM '@abs_srcdir@/data/colcmpr_date.data';
SELECT * FROM colcmpr_date;
 distkey |          a          |          b          |          c          
---------+---------------------+---------------------+---------------------
       1 | 0001-01-01 00:00:00 | 0001-01-01 00:00:00 | 1971-01-01 00:00:00
       1 | 0001-01-02 00:00:00 | 0001-01-02 00:00:00 | 1971-01-02 00:00:00
       1 | 0001-01-03 00:00:00 | 0001-01-03 00:00:00 | 1999-01-01 00:00:00
       1 | 0001-01-04 00:00:00 | 0001-01-04 00:00:00 | 1999-12-31 00:00:00
       1 | 1970-01-01 00:00:00 | 0001-10-10 00:00:00 | 2014-08-19 00:00:00
       1 | 1970-01-02 00:00:00 | 1969-12-28 00:00:00 | 2014-08-20 00:00:00
       1 | 1970-01-03 00:00:00 | 1969-12-29 00:00:00 | 3000-01-01 00:00:00
       1 | 1970-01-04 00:00:00 | 1969-12-30 00:00:00 | 4000-01-01 00:00:00
       1 | 1969-12-31 00:00:00 | 1969-12-31 00:00:00 | 5555-01-01 00:00:00
       1 | 1969-12-30 00:00:00 | 1970-01-01 00:00:00 | 6666-01-01 00:00:00
       1 | 1969-12-29 00:00:00 | 1970-01-02 00:00:00 | 7777-01-01 00:00:00
       1 | 1969-12-28 00:00:00 | 1970-01-03 00:00:00 | 8888-01-01 00:00:00
       1 | 2014-08-18 00:00:00 | 1970-01-04 00:00:00 | 9999-01-01 00:00:00
       1 | 2014-08-19 00:00:00 | 1970-01-05 00:00:00 | 9999-12-31 00:00:00
       1 | 2014-08-20 00:00:00 | 1970-01-06 00:00:00 | 9999-12-30 00:00:00
       1 | 2014-08-21 00:00:00 | 1970-01-07 00:00:00 | 9999-12-29 00:00:00
(16 rows)

DROP TABLE colcmpr_date;
-- problem:
-- test the down-limit value and upmost value about DATE type data
-- including DELTA/RLE/zlib compression methods
CREATE TABLE colcmpr_date_01
(
	distKey int,
	a date,
	b date,
	c date
) with (orientation = column) ;
COPY colcmpr_date_01 FROM '@abs_srcdir@/data/colcmpr_date_01.data';
ERROR:  invalid data for "year =  294276", value must be between -4712 and 9999, and not be 0
CONTEXT:  COPY colcmpr_date_01, line 5, column c: "294276-01-01 AD"
SELECT * FROM colcmpr_date_01;
 distkey | a | b | c 
---------+---+---+---
(0 rows)

DROP TABLE colcmpr_date_01;