cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Benjamin Lerer (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-10263) Insert in Cassandra in a collection, values with single quote
Date Mon, 12 Oct 2015 19:00:07 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-10263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14953569#comment-14953569
] 

Benjamin Lerer commented on CASSANDRA-10263:
--------------------------------------------

Cassandra returns the collection values without quotes. Therefore, if you retrieve the values
from a driver they will not contains double quotes.

{{cqlsh}} print the collection values {{quoted}} and by consequence also escape the single
quotes.
The behavior might be surprising but it is the expected one.

> 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
>            Assignee: Benjamin Lerer
>         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:  {code}INSERT INTO test (name, foo) VALUES ( 'jos''emy',{'foo':'josemy''s houñse'});{code}
> Query: {{SELECT * FROM  test;}}
> {code}
>  name    | foo
> -----------+-----------------------------
>  jos'emy | {'foo': 'josemy''s houñse'}
> {code}
> 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:
> {code}
>  name    | foo
> ---------+-----------------------------
>  jos'emy |   {'foo': 'josemy's houñse'}
> {code}



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

Mime
View raw message