cassandra-commits mailing list archives

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


Sylvain Lebresne commented on CASSANDRA-8781:

I'm not against adding this for the convenience, but for the sake of managing expectations,
I'll note that "allowing the reuse of SQL DBAL" is not a design goal of CQL and as such I'm
mark this as a minor improvement. I'll also note that as a consequence if it turns that this
require non trivial changes (I haven't looked closely), this might not be targeted to 2.1.

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