[IGNITE-20454] Sql. Extend SQL cursor with ability to check if first page is ready

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Done
• Fix Version/s: 3.0
• Component/s: sql
• Labels: ignite-3
• Epic Link: Basic Multi Statement Support
• Assignee: Pavel Pereslegin
• Reporter: Konstantin Orlov
• Created: 20/Sep/23 07:15
• Updated: 04/Sep/24 16:10
• Resolved: 19/Oct/23 10:56

Description

For multi statement queries, in order to advance to the next statement we have to get sure that the first page of result for current statement is ready to be served. This allows not to depend on a user and finish the script even if no one consumes the results.

Definition of done: there is an API available from within SqlQueryProcessor such that will allow to be notified about completion of prefetch (AsyncRootNode#prefetch).

Issue Links

• blocks: IGNITE-20443 Sql. Implement script processing logic.
• links to: GitHub Pull Request #2674