cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Stupp (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-13958) [CQL] Inconsistent handling double dollar sign for strings
Date Fri, 10 Nov 2017 10:45:02 GMT

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

Robert Stupp commented on CASSANDRA-13958:
------------------------------------------

I've played around with various forms of pg-style strings in CASSANDRA-7769 (the ticket that
introduced this).
TL;DR there is [a form|https://issues.apache.org/jira/browse/CASSANDRA-7769?focusedCommentId=14120240&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14120240]
that can handle all this, but making that work in cqlsh turned out to be super difficult.
TBH, I think that is the only viable and probably non-surprising way.

> [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
>            Assignee: Michał Szczygieł
>            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