[client-v2] Fixes handling empty results while using reader

[chernser]

Summary

BinaryFormatReader implementation is stateful and hold current record to be accessible before calling next(). Data is provided as stream and because of this reason handling hasNext() is complex because reader should read data upfront without affect current own position to avoid skipping records. This PR fixes detecting if no data is present in data stream.

Note

There are two cases of empty result:

• SELECT 1 LIMIT 0 - has no result data but has column name and type
• CREATE TABLE test - has nothing at all, so readers that expect schema before data should also handle it correctly.

Closes https://github.com/ClickHouse/clickhouse-java/issues/1788

Checklist

Delete items not relevant to your PR:

• [x] Unit and integration tests covering the common scenarios were added
• [x] A human-readable description of the changes was provided to include in CHANGELOG
• [ ] For significant changes, documentation in https://github.com/ClickHouse/clickhouse-docs was updated with further explanations or tutorials

[sonarcloud[bot]]

Quality Gate passed

Issues
3 New issues
0 Accepted issues

Measures
0 Security Hotspots
100.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarCloud