Revert "Do not paginate in ResultSet when offset not specified"

This reverts commit 82e762d5c14d3dbd18cda4d7e75278aa88817610.