When pagination is used with offset and returns no tuples while several
tuples were actually skipped by offset, iterator has non-NULL position,
that is why select returns non-empty position. Let's check if resulting
tuples were actually found before return position.

NO_CHANGELOG=bugfix for unreleased feature
NO_DOC=bugfix

Part of #7639