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

Paged Range Slice queries with DISTINCT can drop rows from results

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • 2.1.21, 2.2.14
    • CQL/Interpreter
    • None
    • Normal

    Description

      If we have a partition where the first CQL row is fully deleted (possibly via TTLs), and that partition happens to fall on the page boundary of a paged range query which is using SELECT DISTINCT, the next live partition after it is omitted from the result set. This is due to over fetching of the pages and a bug in trimming those pages where overlap occurs.

      This does not affect 3.0+.

      Attachments

        Activity

          People

            samt Sam Tunnicliffe
            samt Sam Tunnicliffe
            Sam Tunnicliffe
            Marcus Eriksson
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: