[CASSANDRA-13332] wrong number of rows in cqlsh

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Duplicate
• Component/s: Legacy/Tools

Environment

Windows 10

• Severity: Low
• Assignee: Unassigned
• Reporter: Bogusz Jelinski
• Created: 15/Mar/17 14:06
• Updated: 16/Apr/19 09:30
• Resolved: 27/Mar/17 08:40

Description

when I send a query via JDBC I receive fewer rows than via CQLSH. What I can see is that at each page/list break the last row is duplicated - replicated to the next page of the list. I have 8 page breaks and the summary of my query gives 8 rows more than my Java client.
It might be of no importance - I am querying a table with "WHERE columnA LIKE '%ABCD%'" for which I created an index:
CREATE CUSTOM INDEX columnA_idx ON ab.cdef (columnA) using 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS =

{ 'mode': 'CONTAINS' }

;

Issue Links

• is broken by: CASSANDRA-13302 last row of previous page == first row of next page while querying data using SASI index