[jira] [Created] (CASSANDRA-6172) COPY TO command doesn't escape single quote in collections

["Ivan Mykhailov (JIRA)" <ji...@apache.org>]

Ivan Mykhailov created CASSANDRA-6172:
-----------------------------------------

             Summary: COPY TO command doesn't escape single quote in collections
                 Key: CASSANDRA-6172
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6172
             Project: Cassandra
          Issue Type: Bug
          Components: Tools
         Environment: Cassandra 2.0.1, Linux
            Reporter: Ivan Mykhailov


CREATE TABLE test (key text PRIMARY KEY , testcollection set<text>) ;
INSERT INTO test (key, testcollection ) VALUES ( 'test', {'foo''bar'});
COPY test TO '/tmp/test.csv';
COPY test FROM '/tmp/test.csv';

Bad Request: line 1:73 mismatched character '<EOF>' expecting '''
Aborting import at record #0 (line 1). Previously-inserted values still present.

Content of generated '/tmp/test.csv':
test,{'foo'bar'}

Unfortunately, I didn't find workaround with any combination of COPY options 



--
This message was sent by Atlassian JIRA
(v6.1#6144)