--
-- 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;
 char_length | char_length 
-------------+-------------
(0 rows)

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
);
NOTICE:  CREATE TABLE will create implicit sequence "lineitem_seq_l_id2_seq" for serial column "lineitem_seq.l_id2"
SELECT COUNT(*) FROM LINEITEM_SEQ;
 count 
-------
     0
(1 row)

SELECT DISTINCT COUNT(L_ID) FROM  LINEITEM_SEQ;
 count 
-------
     0
(1 row)

SELECT DISTINCT COUNT(L_ID2) FROM  LINEITEM_SEQ;
 count 
-------
     0
(1 row)

SELECT MAX(L_ID2) FROM  LINEITEM_SEQ;
 max 
-----
    
(1 row)

TRUNCATE LINEITEM_SEQ;
CREATE SEQUENCE noCacheSeq;  
SELECT COUNT(*) FROM LINEITEM_SEQ;
 count 
-------
     0
(1 row)

SELECT DISTINCT COUNT(L_ID) FROM  LINEITEM_SEQ;
 count 
-------
     0
(1 row)

SELECT DISTINCT COUNT(L_ID2) FROM  LINEITEM_SEQ;
 count 
-------
     0
(1 row)

SELECT MAX(L_ID2) FROM  LINEITEM_SEQ;
 max 
-----
    
(1 row)

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