Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
The problem occurs when cpimport is called with the -m 1 arg or a multi-functional setup is used.
Schema:
CREATE TABLE t1 ( |
col1 INTEGER, |
col2 VARCHAR(255) |
) Engine=ColumnStore;
|
Prepare data & invoke import:
$ for i in $(seq 1 3); do echo $i,test string $i - ok; done > /tmp/t1.csv
|
$ echo -n 4,test string 4 - not ok >> /tmp/t1.csv
|
$ cpimport -m 1 -s , test t1 /tmp/t1.csv
|
Result:
SELECT * FROM t1; |
-- +------+-----------------------+
|
-- | col1 | col2 |
|
-- +------+-----------------------+
|
-- | 1 | test string 1 - ok |
|
-- | 2 | test string 2 - ok |
|
-- | 3 | test string 3 - ok |
|
-- | 4 | test string 4 - not o |
|
-- +------+-----------------------+ |
Expected result:
-- +------+------------------------+
|
-- | 1 | test string 1 - ok |
|
-- | 2 | test string 2 - ok |
|
-- | 3 | test string 3 - ok |
|
-- | 4 | test string 4 - not ok |
|
-- +------+------------------------+ |