[CASSANDRA-8087] Multiple non-DISTINCT rows returned when page_size set

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.0.12
• Labels: qa-resolved
• Severity: Low
• Since Version: 2.0.9
• Assignee: Tom Hobbs
• Reporter: Adam Holmberg

Authors

Tom Hobbs

Reviewers

Sylvain Lebresne

• Tester: Philip Thompson
• Created: 08/Oct/14 21:22
• Updated: 16/Apr/19 09:31
• Resolved: 19/Dec/14 18:31

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

Issue Links

• duplicates: CASSANDRA-8108 Errors paging DISTINCT queries on static columns