Ensure a ResultSet can be iterated and consumed only once

Description

This is partially true at the moment. We can consume the same page multiple times if we want. We should remove rows when consumed (internal _current_rows) rather than just returning it.

Validate with the java driver to have the same behavior.

Environment

None

Pull Requests

None

Assignee

Unassigned

Reporter

Alan Boudreault

Fix versions

None

Labels

None

PM Priority

None

External issue ID

None

Doc Impact

None

Reviewer

None

Size

None

Pull Request

None

Sprint

Py P-MAJOR-NEXT

Priority

Major