Abhijeet Singh created CASSANDRA-15458:
------------------------------------------

             Summary: CQL: Unable to escape single quote in a map<int,text> 
attribute
                 Key: CASSANDRA-15458
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-15458
             Project: Cassandra
          Issue Type: Bug
          Components: CQL/Interpreter, CQL/Semantics
            Reporter: Abhijeet Singh
         Attachments: cass-screen.png

h3. Overview

For {{text}} attributes, CQL allows escaping single quote [using additional 
single 
quote|http://mail-archives.apache.org/mod_mbox/cassandra-user/201108.mbox/%3c20110803152250.294...@gmx.net%3E].
 But applying the same syntax for a {{map<int,text>}} attribute does not work. 
Inconsistent behavior was observed between {{text}} datatype and 
{{map<int,text>}} datatype.
h3. CQL semantic proposal

Cassandra (CQL) should apply same escaping semantics on {{text}} and 
text-within-map {{map<int,text>}} datatypes.
h3. Reproducing the bug:

CREATE query: {{}}
{code:java}

{code}
{{CREATE TABLE university.test (id int, data map<int, text>, PRIMARY KEY 
(id));}}

 

INSERT query: {{}}
{code:java}

{code}
{{insert into university.test (id, data) values(1, \{1:'I''m newb'});}}

 

{{}}

On running the aforementioned INSERT query, Cassandra inserts and returns {{{1: 
'I''m newb'}}} while the expected result is {{{1: 'I'm newb'}}}
h3. Technical details 

OS: CentOS 7

Kernel: Linux 3.10.0-1062.9.1.el7.x86_64

Cassandra version: 3.11.5

Screenshot: [Output after SELECT query|[https://i.stack.imgur.com/PLAan.png]]
  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org

Reply via email to