Skip to content

Commit a02617b

Browse files
authored
fix: remove unnecessary WHEREs from AcquireProvisionerJob (#5257)
1 parent 137a48c commit a02617b

File tree

2 files changed

+2
-4
lines changed

2 files changed

+2
-4
lines changed

coderd/database/queries.sql.go

+1-2
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

coderd/database/queries/provisionerjobs.sql

+1-2
Original file line numberDiff line numberDiff line change
@@ -19,8 +19,7 @@ WHERE
1919
provisioner_jobs AS nested
2020
WHERE
2121
nested.started_at IS NULL
22-
AND nested.canceled_at IS NULL
23-
AND nested.completed_at IS NULL
22+
-- Ensure the caller has the correct provisioner.
2423
AND nested.provisioner = ANY(@types :: provisioner_type [ ])
2524
-- Ensure the caller satisfies all job tags.
2625
AND nested.tags <@ @tags :: jsonb

0 commit comments

Comments
 (0)