[CASSANDRA-8216] Select Count with Limit returns wrong value

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.2.0 beta 1
• Labels: qa-resolved
• Severity: Normal
• Since Version: 2.2.0 beta 1
• Assignee: Benjamin Lerer
• Reporter: Philip Thompson

Authors

Benjamin Lerer

• Tester: Philip Thompson
• Created: 29/Oct/14 19:16
• Updated: 16/Apr/19 09:31
• Resolved: 08/Oct/15 19:51

Description

The dtest cql_tests.py:TestCQL.select_count_paging_test is failing on trunk HEAD but not 2.1-HEAD.

The query

 select count(*) from test where field3 = false limit 1; 

is returning 2, where obviously it should only return 1 because of the limit. This may end up having the same root cause of #8214, I will be bisecting them both soon.

Issue Links

• is related to: CASSANDRA-10487 Regression in select count with limit
• relates to: CASSANDRA-4914 Aggregation functions in CQL