10000 refactor: minor improvement in SQL query · coder/coder@0b2bbee · GitHub
[go: up one dir, main page]
Skip to content

Commit 0b2bbee

Browse files
evgeniy-scherbinaevgeniy-scherbina
committed
refactor: minor improvement in SQL query
1 parent eb80919 commit 0b2bbee

File tree

2 files changed

+2
-2
lines changed

2 files changed

+2
-2
lines changed

‎coderd/database/queries.sql.go

Lines changed: 1 addition & 1 deletion
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/queries/prebuilds.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -115,7 +115,7 @@ WHERE w.id IN (
115115
-- The prebuilds system should never try to claim a prebuild for an inactive template version.
116116
-- Nevertheless, this filter is here as a defensive measure:
117117
AND b.template_version_id = t.active_version_id
118-
AND b.template_version_preset_id = @preset_id::uuid
118+
AND p.current_preset_id = @preset_id::uuid
119119
AND p.ready
120120
LIMIT 1 FOR UPDATE OF p SKIP LOCKED -- Ensure that a concurrent request will not select the same prebuild.
121121
)

0 commit comments

Comments
 (0)
0