[CASSANDRA-8781] SELECT * FROM cf WHERE (id=1) AND (id=1); error

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Later
• Assignee: Benjamin Lerer
• Reporter: Sergey Nagaytsev

Authors

Benjamin Lerer

• Created: 11/Feb/15 09:34
• Updated: 16/Apr/19 09:31
• Resolved: 13/Feb/15 16:17

Description

Error: CQLSTATE[HY000] [2] id cannot be restricted by more than one relation if it includes an Equal

Actual query is with UUID type, 1's are just for short. The column 'id' is the only primary key in column family.

The expression is perfectly logically valid and resolves to one or none record.

It was generated by framework's DBAL as the result of narrowing down the query. Fixing it on application side will take deep heavy rewrite of all DB libs in all languages.