[BUG] A page request with sorting is adding the sort to the count query

[svankamamidi1]

Describe the bug
A page request with sorting is adding the sort to the count query which is creating a lot of performance issues for large data.

Exception or Stack Trace
The count query takes exceptionally high RUs

To Reproduce
Steps to reproduce the behavior:
Create a page request with sorting.
Execure a find with paged results.

Code Snippet
CosmosPageRequest pageable = CosmosPageRequest.of((long) pageInfo.getPageNumber() * maxResults,
pageInfo.getPageNumber(), maxResults.intValue(), pageInfo.getContinuationToken(),
Sort.by(Direction.fromString(sortDirection), sortColumn));
Page currentPageResults = recipientMessageRepository.findByRecipientId(recipientId, pageable)

is generating these queries:
SELECT * FROM ROOT r WHERE r.recipientId = @recipientId0 ORDER BY r.sendDate DESC

SELECT VALUE COUNT(1) FROM r WHERE r.recipientId = @recipientId0 ORDER BY r.sendDate DESC

Expected behavior
Sorting shouldn't be applied to the count query.

Screenshots
If applicable, add screenshots to help explain your problem.

Setup (please complete the following information):

• OS: Windows 10
• IDE: Eclipse
• Library/Libraries: [e.g. com.azure:azure-cosmos-spring-data:3.13.0
• Java version: 8
• App Server/Environment: Tomcat
• Frameworks: Spring Boot

Additional context
We are using page results instead of slice due to an existing issue in azure-cosmos-spring-data library. (#24956)

[kushagraThapar]

@svankamamidi1 - looking at it.

[svankamamidi1]

Please let us know the update on the hotfix release?

[trande4884]

This issue was resolved in the following PR: #29841