TYPO3 Core

Related:

• https://github.com/georgringer/news/issues/1712

The problem is in TYPO3\CMS\Extbase\Pagination\QueryResultPaginator. It overrides the original offset within the query of the items to be paginated. The method updatePaginatedItems should be updated as follows:
protected function updatePaginatedItems(int $limit, int $offset): void {
$origOffset=$this->paginatedQueryResult = $this->queryResult
>getQuery()>getOffset();

$this->paginatedQueryResult = $this->queryResult
             ->getQuery()
             ->setLimit($limit)
             ->setOffset($origOffset+$offset)
             ->execute();
     }

I have tested it and it works perfectly for offset and limit

Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/80326

Patch set 3 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/80326

Patch set 4 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/80326