[ https://issues.apache.org/jira/browse/CASSANDRA-8705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14298449#comment-14298449 ]
Robert Stupp commented on CASSANDRA-8705: ----------------------------------------- If we would allow escapes, it would break a lot of existing applications. TBH I don't think that newlines are a good choice to use in parts of the primary key. IMO you will run into problems when developing on mixed environments that use different line endings like CR-LF or LF (e.g. in script files). The easier solution, if you really want to do it with newlines, might be to use Devcenter from datastax.com web site. > 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)