cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "T Jake Luciani (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4716) CQL3 predicate logic is reversed when used on a reversed column
Date Mon, 01 Oct 2012 19:47:07 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-4716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13467134#comment-13467134
] 

T Jake Luciani commented on CASSANDRA-4716:
-------------------------------------------

How deeply do we want to fix this? It goes pretty deep into how we deal with isReversed flag
vs ReversedType.

We can, however easily fix it in the CQLParser by just flipping the predicates signs around.
                
> CQL3 predicate logic is reversed when used on a reversed column
> ---------------------------------------------------------------
>
>                 Key: CASSANDRA-4716
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4716
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 1.1.0
>            Reporter: T Jake Luciani
>            Assignee: Sylvain Lebresne
>             Fix For: 1.1.6
>
>
> Example:
> {code}
> cqlsh:test>
> cqlsh:test> CREATE TABLE testrev (
>         ... key text,
>         ... rdate timestamp,
>         ... num double,
>         ... PRIMARY KEY(key,rdate)
>         ... ) WITH COMPACT STORAGE
>         ...   AND CLUSTERING ORDER BY(rdate DESC);
> cqlsh:test> INSERT INTO testrev(key,rdate,num) VALUES ('foo','2012-01-01',10.5);
> cqlsh:test> select key from testrev where rdate > '2012-01-02' ;
>  key 
> -----
>  foo 
> cqlsh:test> select key from testrev where rdate < '2012-01-02' ;
> cqlsh:test>
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message