Optimistic Direct Execution in case of Partition Split/Merge

[adityasa]

We are continuously addressing and improving the SDK, if possible, make sure the problem persist in the latest SDK version.

Describe the bug
Optimistic Direct Execution may result in incorrect results when partition split/merge occurs in the backend while query execution is in progress.

To Reproduce
Execute various queries (especially ORDER BY/GROUP BY queries) using optimistic direct execution. Induce partition split mid-way through execution. Results are often incorrect.