[IGNITE-19493] Sql. Query flow refactoring.

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: ignite-3
• Epic Link: Catalog Service
• Assignee: Evgeny Stanilovsky
• Reporter: Andrey Mashenkov
• Created: 17/May/23 09:43
• Updated: 08/Jun/23 08:04
• Resolved: 08/Jun/23 08:04

Description

As of now, in SqlQueryProcessor.querySingle0(), we get SQL SchemaPlus from SqlQueryManager, then create query context, then start implicit transaction if needed.
SqlQueryManager doesn't aware of schema versions.

Let's

• add tx timestamp to the interface, it is ok to ignore the tx timestamp parameter in current implementation unless a new one based on Catalog will be implemented in IGNITE-19496.
• rework current flow to start implicit transaction first, then get a schema based on Tx timestamp, then create a query context.

Issue Links

• relates to: IGNITE-19496 Sql. Implement SqlSchemaManager on top of CatalogService
• links to: GitHub Pull Request #2145
• links to: GitHub Pull Request #2162