[
https://issues.apache.org/jira/browse/CASSANDRA-12232?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alex Petrov updated CASSANDRA-12232:
------------------------------------
Status: Patch Available (was: Open)
As a bonus, we're getting shortcut syntax for counters as well "for free". I've
covered this path with tests as well.
|[trunk|https://github.com/ifesdjeen/cassandra/tree/12232-trunk]
|[utest|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-12232-trunk-testall/]
|[dtest|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-12232-trunk-dtest/]
| ]
> Add +=/-= shortcut syntax
> -------------------------
>
> Key: CASSANDRA-12232
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12232
> Project: Cassandra
> Issue Type: Improvement
> Components: CQL
> Reporter: Sylvain Lebresne
> Assignee: Alex Petrov
> Priority: Minor
>
> For collections and counters, the current syntax to add/remove elements is:
> {noformat}
> UPDATE foo SET myCollection = myCollection + ...;
> {noformat}
> which is fine, though it's already tad annoying to have to repeat
> {{myCollection}}.
> But moving forward, with tickets CASSANDRA-7826, we'll start being able to
> add to nested collections and we'll end up with queries like:
> {noformat}
> UPDATE foo SET myCollection['someElement']['otherElemnt'] =
> myCollection['someElement']['otherElemnt'] + ...;
> {noformat}
> where the repetition is starting to be really annoying and it makes the query
> less readable.
> It's trivial however to add a {{+=}}/{{-=}} shortcut syntax which would read
> instead:
> {noformat}
> UPDATE foo SET myCollection['someElement']['otherElemnt'] += ...;
> {noformat}
> As this would just be syntactic sugar, it only requires a few minor addition
> to the grammar and this would be completely optional: if some users prefer
> the verbose syntax, that's fine.
> Also note that while this will be even more useful after things like
> CASSANDRA-7826, it's already a nice to have today so it's not dependent on
> that latter ticket in any way.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
