In my Cassandra database for a particular query, I have 8 records, and I am using GoLang relops/cqlc library.
When I query with limit = 8, it returns 8 records with a PageState which is to be used as page token for the next set of results. I don't think it should have returned that PageState. And also as expected when I query again with that page_token and the same query parameters, it returns no data.
The same thing does not happen if I increase the limit by one more, say 9.
Did someone else face a similar issue? Any hints as to what might be the issue?