[CASSANDRA-7461] operator functionality in CQL

• Type: New Feature
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Component/s: Legacy/CQL
• Labels: cql
• Assignee: Benjamin Lerer
• Reporter: Robert Stupp

Authors

Benjamin Lerer

• Created: 27/Jun/14 10:45
• Updated: 16/Apr/19 09:31
• Resolved: 07/Feb/17 10:28

Description

Intention: Allow operators in CQL

Operators could be decimal arithmetics + - * / or boolen arithmetics | & ! or string 'arithmetics' +

SELECT tab.label + ' = ' + tab.value FROM foo.tab
SELECT * FROM tab WHERE tab.label + ' = ' + tab.value = 'foo = bar'
as well as
CREATE INDEX idx ON tab ( tab.tabel + '=' + tab.value )
or
CREATE INDEX idx ON tab (label) WHERE contains(tab.tabel, 'very-important-key')

Operators could be mapped to UDFs like this:
+ mapped to UDF cstarstd::oper_plus(...)
- mapped to UDF cstarstd::oper_minus(...)
or handled directly via Cql.g in 'special' code

Issue Links

• is duplicated by: CASSANDRA-5505 Please add support for basic arithmetic operations in CQL
• is related to: CASSANDRA-7458 functional indexes
• is related to: CASSANDRA-7391 Partial indexes

Sub-Tasks

• Add support for arithmetic operators: Resolved
• Add support for + and - operations on dates: Resolved