You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "YuJue Li (Jira)" <ji...@apache.org> on 2020/04/01 13:38:00 UTC

[jira] [Created] (IGNITE-12852) Comma in field is not supported by COPY command

YuJue Li created IGNITE-12852:
---------------------------------

             Summary: Comma in field is not supported by COPY command
                 Key: IGNITE-12852
                 URL: https://issues.apache.org/jira/browse/IGNITE-12852
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.8
            Reporter: YuJue Li
             Fix For: 2.8.1


CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); 
 
a.csv: 
1,"a,b",2 
 
COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; 
 
The copy command fails because there is a comma in the second field,but this is a fully legal and compliant CSV format



--
This message was sent by Atlassian Jira
(v8.3.4#803005)