Skip to content

sql/opt: row-level locking and wait policy modes not propagated to index or lookup joins #56941

@Cynthia-Lee97

Description

@Cynthia-Lee97

Describe the problem
I tried to use select for update nowait, but this statement got stuck. There was no result returned and no error was reported.

To Reproduce

  1. Set up CockroachDB Node
  2. CREATE TABLE t(a INT, b INT, c INT, INDEX id (c) STORING (b)); INSERT INTO t VALUES(1, 1, 1), (2, 2, 2),(3, 3, 3);

image
4. See error

Expected behavior
You should report an error instead of being stuck

Environment:

  • CockroachDB version 20.2
  • Server OS Linux
  • Client app cockroach sql

Jira issue: CRDB-2890

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-optimizerSQL logical planning and optimizations.C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)O-communityOriginated from the communityT-sql-queriesSQL Queries Team

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions