[CASSANDRA-5386] CQL Not Handling Descending Clustering Order On A timeuuid Correctly

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 1.2.4

Environment

Apache Cassandra 1.2.3, Mac OS X (Lion), cql 3

• Severity: Normal
• Assignee: Sylvain Lebresne
• Reporter: Gareth Collins

Authors

Sylvain Lebresne

Reviewers

Jonathan Ellis

• Created: 26/Mar/13 19:29
• Updated: 16/Apr/19 09:32
• Resolved: 27/Mar/13 15:18

Description

I raised this issue as a question in the mailing list:

http://www.mail-archive.com/[e-mail]/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)')