cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gareth Collins (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-5386) CQL Not Handling Descending Clustering Order On A timeuuid Correctly
Date Tue, 26 Mar 2013 19:31:15 GMT
Gareth Collins created CASSANDRA-5386:
-----------------------------------------

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


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

Mime
View raw message