[jira] [Commented] (CASSANDRA-4716) CQL3 predicate logic is reversed when used on a reversed column

["T Jake Luciani (JIRA)" <ji...@apache.org>]

    [ 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