Cassandra
  1. Cassandra
  2. CASSANDRA-4936

Less than operator when comparing timeuuids behaves as less than equal.

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Fix Version/s: 1.2.1
    • Component/s: Core
    • Labels:
      None
    • 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

      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.

      1. 4936.txt
        24 kB
        Sylvain Lebresne

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            Sylvain Lebresne
            Reporter:
            Cesar Lopez-Nataren
            Reviewer:
            Tyler Hobbs
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development