Fix Version/s: 1.2.1
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
If we define the following column family using CQL3:
CREATE TABLE useractivity (
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.