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

This reverts commit cf262d1475d5d287ab444a7e55444a79df4ade2a.