[CASSANDRA-10263] Insert in Cassandra in a collection, values with single quote

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Not A Problem
• Severity: Normal
• Assignee: Benjamin Lerer
• Reporter: Jduarte

Authors

Benjamin Lerer

• Created: 03/Sep/15 18:53
• Updated: 17/Jan/23 20:09
• Resolved: 12/Oct/15 18:59

Description

I think there is a problem with single quotes in collection fields. This is what I try:

Table: CREATE TABLE test (name text, foo map<text,text>, PRIMARY KEY(name));

Insert:

INSERT INTO test (name, foo) VALUES ( 'jos''emy',{'foo':'josemy''s houñse'});

Query: SELECT * FROM test;

 name    | foo
-----------+-----------------------------
 jos'emy | {'foo': 'josemy''s houñse'}

As you can see, Cassandra replace the double quote in the simple "name" field, but does not replace the quotes in the field inside the map. The result (I think) should be:

 name    | foo
---------+-----------------------------
 jos'emy |   {'foo': 'josemy's houñse'}

Issue Links

• duplicates: CASSANDRA-15458 CQL: Unable to escape single quote in a map<int,text> attribute
• relates to: CASSANDRA-18170 Document cqlsh single quote escaping behavior on complex vs simple types