[IGNITE-19558] Sql. Use statistics snapshot per sql request.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.0.0-beta1
• Component/s: sql
• Labels: ignite-3
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 24/May/23 09:55
• Updated: 10/Oct/24 09:30
• Resolved: 10/Oct/24 09:30

Description

Now possible situation when in scope of one sql request planning it`s possible to obtain different table row count, check: StatisticsImpl#getRowCount, this can lead to erroneous or not optimal plan. Seems we need smth. like statistics snapshot for such a case.

starting points:

IgniteTableImpl.StatisticsImpl

Issue Links

• is fixed by: IGNITE-23188 Sql. Incorporate table size estimation in query optimizer