[ https://issues.apache.org/jira/browse/CASSANDRA-12959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15744488#comment-15744488 ]
Stefania commented on CASSANDRA-12959: -------------------------------------- For 2.1 the cqlsh tests do not run, so I've launched the dtests [here|http://cassci.datastax.com/job/stef1927-12959-cqlsh-2.1-dtest/]. > copy from csv import wrong values with udt having set when fields are not > specified in correct order in csv > ----------------------------------------------------------------------------------------------------------- > > Key: CASSANDRA-12959 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12959 > Project: Cassandra > Issue Type: Bug > Components: Tools > Reporter: Quentin Ambard > Assignee: Stefania > Fix For: 2.1.x, 2.2.x, 3.0.x, 3.x > > > {quote} > create KEYSPACE test WITH replication = \{ 'class': 'SimpleStrategy', > 'replication_factor': 1\}; > CREATE TYPE test.my_udt ( > first_field text, > second_field frozen<set<text>> > ); > CREATE TABLE test.test ( key text, value my_udt, PRIMARY KEY (key)); > {quote} > The following works as expected : > {quote} > INSERT INTO test.test (key , value ) VALUES ( 'key1', \{second_field: > \{'test1', 'test2'\}, first_field: 'first_field'\}); > key | value > ------+---------------------------------------------------------------- > key1 | \{first_field: 'first_field', second_field: \{'test1', 'test2'\}\} > {quote} > but when inserted using a .csv the result is wrong: > {quote}"key1","\{second_field: \{'test1', 'test2'\}, first_field: > 'first_field'\}" > COPY test.test FROM '~/test.csv'; > key | value > ------+---------------------------------------------------------------------- > key1 | \{first_field: '\{''test1'', ''test2''\}', second_field: > \{'irst_fiel'\}\} > {quote} > it works as expected if the keys are in order: > bq. "key1","\{first_field: 'first_field', second_field: \{'test1', > 'test2'\}\}") -- This message was sent by Atlassian JIRA (v6.3.4#6332)