Is UPDATE IF [condition]where [condition] the inequality supported by Cassandra CQL?
I looked at the link to the language, and it seems that CQL should not support inequality through its grammar. I used the language link here: https://cassandra.apache.org/doc/cql3/CQL.html#updateStmt
What is confusing is that using C # or CQLSH, the query is successful, but when you do the same from Datasax DevCenter, I get an error.
I am using a query similar to the following below:
UPDATE product
SET edit_date = [new_value]
WHERE customer_id = '4' AND code = 'AMZ-ISMDB'
IF edit_date < [new_value]
The results are as follows:
Datasax DevCenter throws an error when trying to execute a script fragment. The error I get complains about the inequality in the UPDATE IF script part.
script ( . ).
, . 29: '<'
CLINQ Datasax #, , , , , edit_date edit_date, .
CQLSH