Linq: using CqlOperator.SubstractAssign to remove an item from a map fails
Description
Steps to reproduce:
1)
create table test (
id text,
items map<text,text>,
primary key (id)
);
2) insert a record with items
3) try and remove some item via Linq/update
Error: Cassandra.InvalidQueryException : Unexpected extraneous bytes after set value
Expected behavior:
The expression should have been translated into efficient statement, like:
DELETE items['some_key'] FROM test WHERE id = 'some_id';
Perhaps, there's some other way to accomplish this?
Environment
None
Activity
Show:
Jorge Bay Gondra
December 19, 2016, 9:12 PM
Indeed is not supported yet, but it should be...
What could be a challenge is that removing map items is done using a CQL DELETE statement, where for lists and sets it is done using a UPDATE.
