[CASSANDRA-12959] copy from csv import wrong values with udt having set when fields are not specified in correct order in csv

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.1.17, 2.2.9, 3.0.11, 3.10
• Component/s: Legacy/Tools
• Severity: Normal
• Assignee: Stefania Alborghetti
• Reporter: Quentin Ambard

Authors

Stefania Alborghetti

Reviewers

Paulo Motta

• Created: 27/Nov/16 17:04
• Updated: 16/Apr/19 09:30
• Resolved: 22/Dec/16 02:32

Description

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));

The following works as expected :

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'}}

but when inserted using a .csv the result is wrong:

"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'}}

it works as expected if the keys are in order:

"key1","{first_field: 'first_field', second_field: {'test1', 'test2'}}")