When searching for content with the SearchService if there is no results because we have "paginated" with an offset the search ends up in an ezc Database exception.

The reason is in the eZ\Publish\Core\Persistence\Legacy\Content\Search\Gateway\EzcDatabase.php file in the method find.

First there is a check to catch if there is no result and then the search is done. The problem is that this check for no result is made with no regard for the offset so the system think that there is result and try to load empty contentIds : it ends up with a wrong query and Zeta Components throws an exception.