[CASSANDRA-4936] Less than operator when comparing timeuuids behaves as less than equal.

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

Environment

Linux CentOS.

Linux localhost.localdomain 2.6.18-308.16.1.el5 #1 SMP Tue Oct 2 22:01:37 EDT 2012 i686 i686 i386 GNU/Linux

• Severity: Normal
• Assignee: Sylvain Lebresne
• Reporter: Cesar Lopez-Nataren

Authors

Sylvain Lebresne

Reviewers

Tom Hobbs

• Created: 09/Nov/12 01:13
• Updated: 16/Apr/19 09:32
• Resolved: 18/Jan/13 13:02

Description

If we define the following column family using CQL3:

CREATE TABLE useractivity (
user_id int,
activity_id 'TimeUUIDType',
data text,
PRIMARY KEY (user_id, activity_id)
);

Add some values to it.

And then query it like:

SELECT * FROM useractivity WHERE user_id = '3' AND activity_id < '2012-11-07 18:18:22-0800' ORDER BY activity_id DESC LIMIT 1;

the record with timeuuid '2012-11-07 18:18:22-0800' returns in the results.

According to the documentation, on CQL3 the '<' and '>' operators are strict, meaning not inclusive, so this seems to be a bug.