cockroachdb / cockroachdb/cockroach
sql: support SKIP LOCKED with multiple column families
Open
branch-release-26.1
C-enhancement
docs-known-limitation
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
When we initially implemented SKIP LOCKED in #85720 we disallowed SKIP LOCKED on tables with multiple column families, because there was a possibility of accidentally reading partial rows in kv_batch_fetcher if only a single column family was locked.
We should explore how to support SKIP LOCKED on tables with multiple column families. We could allow it if only a single column family is scanned.
(This limitation has existed since v22.2 but has not been documented.)
Jira issue: CRDB-58631
Epic CRDB-65887
Contributor guide
Assessment
This issue has not been assessed yet.