#3110 [CM201303] When import string to integer, it display Attribute b cannot be made NULL.

open
nobody
None
5
2013-04-28
2013-04-28
Jira Trac
No

1 create one table

CREATE TABLE nutest(
a character(1) COLLATE iso88591_bin ,
b integer NOT NULL,
CONSTRAINT pk_nutest_b PRIMARY KEY(b)
) COLLATE iso88591_bin ;
ALTER TABLE nutest PARTITION BY RANGE ([[b]]) (PARTITION p1 VALUES LESS THAN (100), PARTITION p2 VALUES LESS THAN (200), PARTITION p3 VALUES LESS THAN (300));

2 import the csv in attachment, it display as in attachment. it is need to display likecannot convert string to int. Not set it to null

Discussion