You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Aleksey Yeschenko (JIRA)" <ji...@apache.org> on 2013/11/04 14:00:18 UTC

[jira] [Resolved] (CASSANDRA-6295) boundstatement query for timeuuid does not work

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

Aleksey Yeschenko resolved CASSANDRA-6295.
------------------------------------------

    Resolution: Invalid

It doesn't work because 'modified' is not part of the primary key. It will with PRIMARY KEY (id, modified).

> boundstatement query for timeuuid does not work
> -----------------------------------------------
>
>                 Key: CASSANDRA-6295
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6295
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: jdk 1.7, cassandra 2.0.2
>            Reporter: koray sariteke
>
> boundstatement query for timeuuid seems does not work. 
> cqlsh return as 
> Bad Request: No indexed columns present in by-columns clause with Equal operator
> create table demo(
> id int,
> modified timeuuid
> primary key(id)
> )
> select * from demo where modified > maxTimeuuid('2013-11-04 14:28:59+0200')
> I also tried with created secondary index, 
> select * from demo where modified = ae5d7bc3-454c-11e3-b090-a3b72c13337d ;
> works but 
> select * from demo where modified > maxTimeuuid('2013-11-04 14:28:59+0200')
> does not work.



--
This message was sent by Atlassian JIRA
(v6.1#6144)