Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-4716

CQL3 predicate logic is reversed when used on a reversed column

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: 1.1.6
    • Component/s: None
    • Labels:
      None
    • Severity:
      Normal

      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>
      

        Attachments

        1. 4716.txt
          4 kB
          Sylvain Lebresne

          Activity

            People

            • Assignee:
              slebresne Sylvain Lebresne
              Reporter:
              tjake T Jake Luciani
              Authors:
              Sylvain Lebresne
              Reviewers:
              T Jake Luciani
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: