--
-- BULK LOAD PARALLEL TEST 2
--
----



CREATE TABLE OVERLOAD_TEST(col1 text,col2 text);


SELECT char_length(col1),char_length(col2) FROM OVERLOAD_TEST ORDER BY col1;

DROP TABLE OVERLOAD_TEST;




Create sequence L_Seq_500cache increment by 1 cache 500 no maxvalue start with 1;  

CREATE TABLE LINEITEM_SEQ 
(
	L_ID   BIGINT NOT NULL DEFAULT nextval('L_Seq_500cache')
  , L_ID2  bigserial
  , L_ORDERKEY    BIGINT NOT NULL
  , L_PARTKEY     BIGINT NOT NULL
  , L_SUPPKEY     BIGINT NOT NULL
  , L_LINENUMBER  BIGINT NOT NULL
  , L_QUANTITY    DECIMAL(15,2) NOT NULL
  , L_EXTENDEDPRICE  DECIMAL(15,2) NOT NULL
  , L_DISCOUNT    DECIMAL(15,2) NOT NULL
  , L_TAX         DECIMAL(15,2) NOT NULL
  , L_RETURNFLAG  CHAR(1) NOT NULL
  , L_LINESTATUS  CHAR(1) NOT NULL
  , L_SHIPDATE    DATE NOT NULL
  , L_COMMITDATE  DATE NOT NULL
  , L_RECEIPTDATE DATE NOT NULL
  , L_SHIPINSTRUCT CHAR(25) NOT NULL
  , L_SHIPMODE     CHAR(10) NOT NULL
  , L_COMMENT      VARCHAR(44) NOT NULL
);



SELECT COUNT(*) FROM LINEITEM_SEQ;
SELECT DISTINCT COUNT(L_ID) FROM  LINEITEM_SEQ;
SELECT DISTINCT COUNT(L_ID2) FROM  LINEITEM_SEQ;
SELECT MAX(L_ID2) FROM  LINEITEM_SEQ;


TRUNCATE LINEITEM_SEQ;
CREATE SEQUENCE noCacheSeq;  


SELECT COUNT(*) FROM LINEITEM_SEQ;
SELECT DISTINCT COUNT(L_ID) FROM  LINEITEM_SEQ;
SELECT DISTINCT COUNT(L_ID2) FROM  LINEITEM_SEQ;
SELECT MAX(L_ID2) FROM  LINEITEM_SEQ;


DROP TABLE LINEITEM_SEQ;
DROP SEQUENCE L_Seq_500cache;
DROP SEQUENCE noCacheSeq;