[
https://issues.apache.org/jira/browse/CASSANDRA-4881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brandon Williams reassigned CASSANDRA-4881:
-------------------------------------------
Assignee: Sylvain Lebresne
> Selecting records on a reversed column in CQL 3 returns wrong row
> -----------------------------------------------------------------
>
> Key: CASSANDRA-4881
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4881
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.2.0 beta 1
> Reporter: Patrick McFadin
> Assignee: Sylvain Lebresne
>
> Using this table:
> CREATE TABLE video_event (
> videoid_username varchar,
> event varchar,
> event_timestamp timestamp,
> video_timestamp timestamp,
> PRIMARY KEY (videoid_username, event, event_timestamp)
> )WITH CLUSTERING ORDER BY (event_timestamp DESC);
> Inserting these records:
> INSERT INTO video_event (videoid_username, event, event_timestamp,
> video_timestamp)
> VALUES ('99051fe9-6a9c-46c2-b949-38ef78858dd0:ctodd','start','2012-09-02
> 18:05:00','2012-09-02 18:05:00');
> INSERT INTO video_event (videoid_username, event, event_timestamp,
> video_timestamp)
> VALUES ('99051fe9-6a9c-46c2-b949-38ef78858dd0:ctodd','stop','2012-09-02
> 18:05:30','2012-09-02 18:05:30');
> INSERT INTO video_event (videoid_username, event, event_timestamp,
> video_timestamp)
> VALUES ('99051fe9-6a9c-46c2-b949-38ef78858dd0:ctodd','start','2012-09-02
> 18:35:00','2012-09-02 18:35:00');
> INSERT INTO video_event (videoid_username, event, event_timestamp,
> video_timestamp)
> VALUES ('99051fe9-6a9c-46c2-b949-38ef78858dd0:ctodd','stop','2012-09-02
> 18:37:30','2012-09-02 18:37:30');
> Running this select:
> select * from video_event where videoid_username =
> '99051fe9-6a9c-46c2-b949-38ef78858dd0:ctodd' limit 1;
> I get this:
> videoid_username | event | event_timestamp
> | video_timestamp
> --------------------------------------------+-------+--------------------------+--------------------------
> 99051fe9-6a9c-46c2-b949-38ef78858dd0:ctodd | start | 2012-09-02
> 18:05:00+0000 | 2012-09-02 18:05:00+0000
> I would expect to see this:
> videoid_username | event | event_timestamp
> | video_timestamp
> --------------------------------------------+-------+--------------------------+--------------------------
> 99051fe9-6a9c-46c2-b949-38ef78858dd0:ctodd | stop | 2012-09-02
> 18:37:30+0000 | 2012-09-02 18:37:30+0000
> where the first record pulled was the sorted record by event_timestamp in
> reverse order.
--
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
