[
https://issues.apache.org/jira/browse/CASSANDRA-5386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13615184#comment-13615184
]
Jonathan Ellis commented on CASSANDRA-5386:
-------------------------------------------
+1
> CQL Not Handling Descending Clustering Order On A timeuuid Correctly
> --------------------------------------------------------------------
>
> Key: CASSANDRA-5386
> URL: https://issues.apache.org/jira/browse/CASSANDRA-5386
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.2.3
> Environment: Apache Cassandra 1.2.3, Mac OS X (Lion), cql 3
> Reporter: Gareth Collins
> Assignee: Sylvain Lebresne
> Fix For: 1.2.4
>
> Attachments: 5386.txt
>
>
> I raised this issue as a question in the mailing list:
> http://www.mail-archive.com/user@cassandra.apache.org/msg28787.html
> If I create a table (cqlsh) with the following schema:
> CREATE TABLE mytable ( column1 text,
> column2 text,
> messageId timeuuid,
> message blob,
> PRIMARY KEY ((column1, column2), messageId));
> I can quite happily add rows to this table:
> insert into client_queue (column1,column2,messageId,message) VALUES
> ('string1','string2',now(),'ABCCDCC123');
> If I however create a table with a desc clustering order on messageid:
> CREATE TABLE mytable ( column1 text,
> column2 text,
> messageId timeuuid,
> message blob,
> PRIMARY KEY ((column1, column2), messageId)) WITH CLUSTERING
> ORDER BY (messageId DESC);
> Inserts are failing. I am getting the following error:
> insert into client_queue2 (column1,column2,messageId,message) VALUES
> ('string1','string2',now(),'ABCCDCC123');
> I get the following error:
> Bad Request: Type error: cannot assign result of function now (type
> timeuuid) to messageid (type
> 'org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.TimeUUIDType)')
--
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
