cassandra-commits mailing list archives

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


Sylvain Lebresne updated CASSANDRA-8781:
    Assignee: Benjamin Lerer

> SELECT * FROM cf WHERE (id=1) AND (id=1); error
> -----------------------------------------------
>                 Key: CASSANDRA-8781
>                 URL:
>             Project: Cassandra
>          Issue Type: Improvement
>            Reporter: Sergey Nagaytsev
>            Assignee: Benjamin Lerer
>            Priority: Minor
> 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