HF RL Explorer

Partial Index Corruption During Concurrent Updates and Index Creation

Partial Index Corruption During Concurrent Updates and Index Creation: a task in LegoFlow-SWE (Harbor dataset). A partial index can become inconsistent with the table data when rows are updated while the index is being created (backfilled). Queries that use the partial index subsequently return…

The task

A partial index can become inconsistent with the table data when rows are updated while the index is being created (backfilled). Queries that use the partial index subsequently return incorrect results—missing rows that should be present, or including rows that no longer satisfy the predicate.

Part of Lego-X/LegoFlow-SWE.