The method DataFrame.readResultSet(resultSet, PostgreSql) could not be read twice

[zaleslaw]

From @Jolanrensen

DataFrame.readResultSet(resultSet, PostgreSql)
cannot be called more than once! This is not expected behavior for me as dataframe calls are always functional. They do not modify the argument.
DataFrame.readResultSet(statement.executeQuery(selectQuery), PostgreSql)
this does work and can be repeated, as expected.

[zaleslaw]

Unfortunately, the nature of the ResultSet object is the following: it has a state, and after reading - the state is updated, it's for experienced developers who have at the moment opened ResultSet in the code

What could we do to avoid this: a will add a warning here, note to KDoc and update the site documentation.

Also there were two another options to implement:

1. Reset a RS under the hood without giving a choice for user - imagine the loosing of control on the RS is also unexpected behaviour for the backend developers
2. Add a flag or another function which will not change the RS - it multiplies behavior for the particular use-case

I suggest make a warning and give a freedom

Also, the initial RS could have different settings, like ResultSet.TYPE_SCROLL_INSENSITIVE or others, and we need to parse them and implement the switch/when lgoc to handle all of them on our side