[jira] [Created] (CASSANDRA-10263) Insert in Cassandra in a collection, values with single quote

[Jduarte (JIRA)]

Jduarte created CASSANDRA-10263:
-----------------------------------

             Summary: Insert in Cassandra in a collection, values with single 
quote
                 Key: CASSANDRA-10263
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-10263
             Project: Cassandra
          Issue Type: Bug
            Reporter: Jduarte
             Fix For: 2.2.1
         Attachments: terminal.png

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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)