[jira] [Created] (CASSANDRA-5713) CQL3 token() <= token() does not work as expected

["Colin B. (JIRA)" <ji...@apache.org>]

Colin B. created CASSANDRA-5713:
-----------------------------------

             Summary: CQL3 token() <= token() does not work as expected
                 Key: CASSANDRA-5713
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5713
             Project: Cassandra
          Issue Type: Bug
            Reporter: Colin B.
            Priority: Minor


Using tokens to go backward through a table in CQL3 does not work as expected.

Say there is some data available:
{code}
> SELECT key FROM data_list where token(key) >= token('6') limit 10;
 key
-----
   6
   7
   9
   4
   3
   A
   5
   8
   2
   1
{code}

I expect:
{code}
> SELECT key FROM data_list where token(key) <= token('1') limit 5;
 key
-----
   A
   5
   8
   2
   1
{code}

However the following occurs:
{code}
> SELECT key FROM data_list where token(key) <= token('1') limit 5;
 key
-----
   6
   7
   9
   4
   3
{code}

The '<' operator has similar unexpected behavior.


--
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