-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql/opt: row-level locking and wait policy modes not propagated to index or lookup joins #56941
Copy link
Copy link
Closed
Labels
A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code 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)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)O-communityOriginated from the communityOriginated from the communityT-sql-queriesSQL Queries TeamSQL Queries Team
Description
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
- Set up CockroachDB Node
- 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);
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
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code 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)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)O-communityOriginated from the communityOriginated from the communityT-sql-queriesSQL Queries TeamSQL Queries Team
