"FOR UPDATE" sql command is in the wrong place
Open
Area - Extension
Area - Metadata
Bug
- Dominant language
- Java
- Stars
- 14.1k
- Forks
- 3.8k
- Avg merge
- 2d 58m
- Merged PRs (30d)
- 233
Description
"FOR UPDATE" is not compatible with SQL SERVER or other several DB, this should be erased from here and use another strategy for locking rows
https://github.com/apache/druid/blob/d5e8d4d68007899df17f390a756422d511d746d5/server/src/main/java/org/apache/druid/metadata/SQLMetadataConnector.java#L476
Contributor guide
Research direction
Start at server/src/main/java/org/apache/druid/metadata/SQLMetadataConnector.java near line 476 and identify where the FOR UPDATE clause is added. Check the supported database behavior and determine a compatible row-locking approach; done means locking works across supported databases without emitting the incompatible clause.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100