Sergey Nagaytsev created CASSANDRA-8781:
-------------------------------------------
Summary: SELECT * FROM cf WHERE (id=1) AND (id=1); error
Key: CASSANDRA-8781
URL: https://issues.apache.org/jira/browse/CASSANDRA-8781
Project: Cassandra
Issue Type: Bug
Reporter: Sergey Nagaytsev
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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
