[
https://issues.apache.org/jira/browse/CASSANDRA-5472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jonathan Ellis updated CASSANDRA-5472:
--------------------------------------
Reviewer: iamaleksey
> Timeuuid with CLUSTERING ORDER DESC cannot be used with the dateOf CQL3
> function
> --------------------------------------------------------------------------------
>
> Key: CASSANDRA-5472
> URL: https://issues.apache.org/jira/browse/CASSANDRA-5472
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Affects Versions: 1.2.4
> Reporter: Gareth Collins
> Assignee: Sylvain Lebresne
> Fix For: 1.2.5
>
> Attachments: 5472.txt
>
>
> I originally raised this issue in the mailing lists:
> http://www.mail-archive.com/user@cassandra.apache.org/msg29185.html
> Here is what I tried:
> cqlsh:location> create table test_y (message_id timeuuid, name text,
> PRIMARY KEY (name,message_id));
> cqlsh:location> insert into test_y (message_id,name) VALUES (now(),'foo');
> cqlsh:location> insert into test_y (message_id,name) VALUES (now(),'foo');
> cqlsh:location> insert into test_y (message_id,name) VALUES (now(),'foo');
> cqlsh:location> insert into test_y (message_id,name) VALUES (now(),'foo');
> cqlsh:location> select dateOf(message_id) from test_y;
> dateOf(message_id)
> --------------------------
> 2013-04-13 00:33:42-0400
> 2013-04-13 00:33:43-0400
> 2013-04-13 00:33:43-0400
> 2013-04-13 00:33:44-0400
> cqlsh:location> create table test_x (message_id timeuuid, name text,
> PRIMARY KEY (name,message_id)) WITH CLUSTERING ORDER BY (message_id DESC);
> cqlsh:location> insert into test_x (message_id,name) VALUES (now(),'foo');
> cqlsh:location> insert into test_x (message_id,name) VALUES (now(),'foo');
> cqlsh:location> insert into test_x (message_id,name) VALUES (now(),'foo');
> cqlsh:location> insert into test_x (message_id,name) VALUES (now(),'foo');
> cqlsh:location> insert into test_x (message_id,name) VALUES (now(),'foo');
> cqlsh:location> select dateOf(message_id) from test_x;
> Bad Request: Type error:
> org.apache.cassandra.cql3.statements.Selection$SimpleSelector@1e7318 cannot
> be passed as argument 0 of function dateof of type timeuuid
> It should be possible to use dateOf on message_id in table test_x
--
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
