happyjoblzp

Filter on 'char' field was error while import data by copy

1

``` default_database=# CREATE TABLE REGION ( R_REGIONKEY INTEGER NOT NULL,R_NAME CHAR(25) NOT NULL,R_COMMENT VARCHAR(152)); CREATE TABLE default_database=# copy region from '/Users/liuliuzhipeng/tpch-dbgen/region.tbl' with(delimiter '|', null ''); COPY 5 default_database=# select *...

``` default_database=# CREATE TABLE test (shipdate DATE NOT NULL); CREATE TABLE default_database=# insert into test values(date '2011-11-12'); INSERT 0 1 default_database=# select * from test; shipdate ------------- 50350-04-03 (1 row)...