Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-6857

SELECT DISTINCT with a LIMIT is broken by paging

Agile BoardAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • 2.0.7
    • None
    • None
    • Normal

    Description

      The paging for RangeSliceCommand only support the case where we count CQL3 rows . However, in the case of SELECT DISTINCT, we do actually want to use the "count partitions, not CQL3 row" path and that's currently broken when the paging commands are used (this was first reported on the Java driver JIRA and there is a reproduction script there).

      Attachments

        1. 6857-2.0.txt
          3 kB
          Sylvain Lebresne
        2. 6857-2.1.txt
          6 kB
          Sylvain Lebresne
        3. 6857-2.0-v2.txt
          5 kB
          Sylvain Lebresne

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            slebresne Sylvain Lebresne Assign to me
            slebresne Sylvain Lebresne
            Sylvain Lebresne
            Tom Hobbs
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment