Greetings.

On this document:

http://cassandra.apache.org/doc/cql3/CQL.html#updateStmt

…I read, under UPDATE section, that: 

"The c = c + 3 form of <assignment> is used to increment/decrement counters. 
The identifier after the ‘=’ sign must be the same than the one before the ‘=’ 
sign (Only increment/decrement is supported on counters, not the assignment of 
a specific value)."


On C* 1.2.1 I see that the following query works:

   update counters set value=value+5 where owner_id='1' and 
counter_type='trash';

...while the following one gives an error (Bad Request: Invalid non-counter 
operation on counter table):

   update counters set value=5 where owner_id='1' and counter_type='trash';


In C* 1.2.2. the latter started to work. Beside the fact that this is Great(™), 
is this something planned and I missed something ? And, more important, 
wouldn't be a Great(™) idea to allow direct setting of counters in INSERT too, 
with the side effect of making COPY FROM works even for counters table ?

I am about to open a ticket on Jira, but before doing this I want to be sure I 
didn't miss anything.

Thanks.

--
Marco Matarazzo
== Hex Keep ==

W: http://www.hexkeep.com
M: +39 347 8798528
E: marco.matara...@hexkeep.com

"You can learn more about a man
  in one hour of play
  than in one year of conversation.” - Plato




Reply via email to