[jira] [Commented] (CASSANDRA-8705) cqlsh doesn't handle new line escape character inside string literals

["Robert Stupp (JIRA)" <ji...@apache.org>]

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

Robert Stupp commented on CASSANDRA-8705:
-----------------------------------------

[~mlowicki] can you specify which C* version are you using? And please verify if it's not a CR-LF vs. LF issue since a quick experiment in cqlsh works for me. Also note, that escape sequences ({{\n}}) are not supported inside string constants in CQL3 (and I think in cqlsh, too).
{noformat}
cqlsh:foo> create table bla (key text primary key, val text);
cqlsh:foo> insert into bla (key, val ) values ('hello
       ... world', 'ciao');
cqlsh:foo> select * from bla;

 key          | val
--------------+------
 hello\nworld | ciao

(1 rows)
cqlsh:foo> select * from bla where key = 'hello
       ... world';

 key          | val
--------------+------
 hello\nworld | ciao

(1 rows)
cqlsh:foo> 
{noformat}

> cqlsh doesn't handle new line escape character inside string literals
> ---------------------------------------------------------------------
>
>                 Key: CASSANDRA-8705
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8705
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: mlowicki
>
> {code}
> cqlsh:sync> select count(*) from entity where user_id='255824802' and parent_id='MzI5MDReMV48c2VydmVyIHRhZz50cmFzaF9ib29rbWFya3M=
>         ... ';
>  count
> -------
>      1
> (1 rows)
> cqlsh:sync> select count(*) from entity where user_id='255824802' and parent_id='MzI5MDReMV48c2VydmVyIHRhZz50cmFzaF9ib29rbWFya3M=\n';
>  count
> -------
>      0
> (1 rows)
> {code}



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