[ 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)