[ 
https://issues.apache.org/jira/browse/CASSANDRA-13462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Andrew Jefferson updated CASSANDRA-13462:
-----------------------------------------
    Comment: was deleted

(was: cqlsh> select * from dev.testinguuids where pk=6 ORDER BY ck ;

 pk | ck                                   | val
----+--------------------------------------+-----
  6 | 10000000-0000-0200-0000-000000000000 |   1
  6 | 20000000-0000-0200-0000-000000000000 |   1
  6 | 10000000-0000-1200-0000-000000000000 |   1
  6 | 20000000-0000-1200-0000-000000000000 |   1
  6 | 10000000-0000-2200-0000-000000000000 |   1
  6 | 20000000-0000-2200-0000-000000000000 |   1)

> Unexpected behaviour with range queries on UUIDs
> ------------------------------------------------
>
>                 Key: CASSANDRA-13462
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-13462
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Andrew Jefferson
>
> My expectation is that UUIDs should behave as 128 bit integers for comparison.
> However it seems that the Cassandra implementation compares first the uuid 
> version number, then the remaining values of the uuid.
> e.g. in C*
>  10000000-0000-3000-0000-000000000000
>  is greater than 
> 20000000-0000-1000-0000-000000000000 
> (n.b. the 13th value is the uuid version)
>  - this is consistent across range queries and using ORDER BY 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to