[IGNITE-17330] Support RO TX by SQL

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0-beta1
• Component/s: sql
• Labels: ignite-3
• Epic Link: Ignite 3 transactions
• Assignee: Evgeny Stanilovsky
• Reporter: Iurii Gerzhedovich
• Created: 07/Jul/22 10:58
• Updated: 27/Oct/22 17:53
• Resolved: 27/Oct/22 17:53

Description

SQL use RW transaction mode. It's not efficient in case we need just read consistent data.

After implementing IGNITE-17260 we should add support RO transaction for SQL queries. Seems required just use transaction method with timestamp (org.apache.ignite.hlc.HybridClock#now) as parameter.

Issue Links

• Dependency: IGNITE-17260 Enrich IgniteTransactions and Transaction interfaces with RO related methods
• links to: GitHub Pull Request #1232
• links to: GitHub Pull Request #1232