Avoid additional totalRecords SQL query for offset=0 limit=MAX_INT

Description

CqlQuery’s get(String cqlQuery, int offset, int limit) method always executes the additional SQL query that calculates the totalRecords estimation.

This additional SQL query is not needed and should not execute if offset=0 and limit=MAX_INT because the main SQL query returns all records so that the exact totalRecords number can easily been determined from the result set size.

Environment

None

Potential Workaround

None

Checklist

hide

Activity

Show:
Done

Details

Assignee

Reporter

Priority

Development Team

Spitfire

Release

Quesnelia (R1 2024)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created February 29, 2024 at 3:30 PM
Updated March 18, 2024 at 1:57 PM
Resolved March 4, 2024 at 10:18 AM
TestRail: Cases
TestRail: Runs