cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hugo Picado (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-13958) [CQL] Inconsistent handling double dollar sign for strings
Date Mon, 16 Oct 2017 12:16:00 GMT
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: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org


Mime
View raw message