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

Multiple non-DISTINCT rows returned when page_size set

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Low
    • Resolution: Fixed
    • Fix Version/s: 2.0.12
    • Component/s: None
    • Labels:
    • Severity:
      Low
    • Since Version:

      Description

      Using the following statements to reproduce:

      CREATE TABLE test (
                      k int,
                      p int,
                      s int static,
                      PRIMARY KEY (k, p)
                  );
      INSERT INTO test (k, p) VALUES (1, 1);
      INSERT INTO test (k, p) VALUES (1, 2);
      SELECT DISTINCT k, s FROM test ;
      

      Native clients that set result_page_size in the query message receive multiple non-distinct rows back (one per clustered value p in row k).

      This is only reproduced on 2.0.10. Does not appear in 2.1.0

      It does not appear in cqlsh for 2.0.10 because thrift.

      See https://datastax-oss.atlassian.net/browse/PYTHON-164 for background

        Attachments

        1. 8087-2.0-v2.txt
          10 kB
          Tyler Hobbs
        2. 8087-2.0.txt
          11 kB
          Tyler Hobbs

          Issue Links

            Activity

              People

              • Assignee:
                thobbs Tyler Hobbs
                Reporter:
                aholmber Adam Holmberg
                Authors:
                Tyler Hobbs
                Reviewers:
                Sylvain Lebresne
                Tester:
                Philip Thompson
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: