cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Nagaytsev (JIRA)" <>
Subject [jira] [Created] (CASSANDRA-8781) SELECT * FROM cf WHERE (id=1) AND (id=1); error
Date Wed, 11 Feb 2015 09:35:12 GMT
Sergey Nagaytsev created CASSANDRA-8781:

             Summary: SELECT * FROM cf WHERE (id=1) AND (id=1); error
                 Key: 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

View raw message