[IGNITE-11311] MVCC: SQL full table scan query can return duplicates.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Component/s: mvcc, sql
• Labels: mvcc_stability
• Assignee: Unassigned
• Reporter: Andrey Mashenkov
• Created: 13/Feb/19 11:09
• Updated: 25/Aug/23 08:35
• Resolved: 25/Aug/23 08:35

Description

SQL query like "select * from table" can return duplicate rows.

Possible reasons are

• SQL query iterates over data pages directly and can see inconsistent state (IGNITE-10561) 
• Query see stale pages. See IGNITE-10767 for details.
• Smth is wrong with mvcc versions visibility.

Issue Links

• is caused by: IGNITE-11247 MVCC: Tests has been forgotten to unmute.
• relates to: IGNITE-9949 MVCC TX: Scan query can return wrong result on unstable topology