Hugo Picado created CASSANDRA-13958:
---------------------------------------
Summary: [CQL] Inconsistent handling double dollar sign for strings
Key: CASSANDRA-13958
URL: https://issues.apache.org/jira/browse/CASSANDRA-13958
Project: Cassandra
Issue Type: Bug
Components: CQL
Reporter: Hugo Picado
Priority: Minor
Double dollar signs is a [built-in method for escaping columns that may contain
single quotes in its
content](https://docs.datastax.com/en/cql/3.3/cql/cql_reference/escape_char_r.html).
The way this is handled however is not consistent, in the sense that it allows
for $ to appear in the middle of the string but not in the last char.
*Examples:*
Valid: insert into users(id, name) values(1, $$john$$)
Inserts the string *john*
Valid: insert into users(id, name) values(1, $$jo$hn$$)
Inserts the string *jo$hn*
Valid: insert into users(id, name) values(1, $$$john$$)
Inserts the string *$john*
Invalid: insert into users(id, name) values(1, $$john$$$)
Fails with:
{code}
Invalid syntax at line 1, char 48
insert into users(id, name) values(1, $$john$$$);
{code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
