8000 opt: support multi-column-family checks during updates under read committed isolation · Issue #112488 · cockroachdb/cockroach · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
opt: support multi-column-family checks during updates under read committed isolation #112488
New issue
New issue
Open
Open
opt: support multi-column-family checks during updates under read committed isolation#112488
Labels
A-read-committedRelated to the introduction of Read CommittedA-sql-optimizerSQL logical planning and optimizations.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Teamdocs-donedocs-known-limitation
@michae2

Description

@michae2
michae2
opened on Oct 17, 2023

When performing an UPDATE, UPSERT, or INSERT ON CONFLICT into a table with multiple column families, if there is a multi-column check constraint on the table that involves multiple column families we might read some column families that are not modified. Under Read Committed isolation we need to take shared locks when reading these unmodified column families, to maintain the check constraint in the face of concurrent modifications. We currently do not do this, so this is disallowed under Read Committed isolation.

Jira issue: CRDB-32442

Epic CRDB-38938

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-read-committedRelated to the introduction of Read CommittedA-sql-optimizerSQL logical planning and optimizations.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Teamdocs-donedocs-known-limitation

    Type

    No type

    Projects

    SQL Queries

    Status

    Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions
      0