[CASSANDRA-4716] CQL3 predicate logic is reversed when used on a reversed column

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 1.1.6
• Severity: Normal
• Assignee: Sylvain Lebresne
• Reporter: T Jake Luciani

Authors

Sylvain Lebresne

Reviewers

T Jake Luciani

• Created: 25/Sep/12 15:00
• Updated: 16/Apr/19 09:32
• Resolved: 02/Oct/12 16:52

Description

Example:

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>