coder
diff --git a/‎coderd/database/querier.go
Lines changed: 0 additions & 1 deletion b/‎coderd/database/querier.go
Lines changed: 0 additions & 1 deletion
diff --git a/‎coderd/database/querier_test.go
Lines changed: 2 additions & 2 deletions b/‎coderd/database/querier_test.go
Lines changed: 2 additions & 2 deletions
diff --git a/‎coderd/database/queries.sql.go
Lines changed: 1 addition & 3 deletions b/‎coderd/database/queries.sql.go
Lines changed: 1 addition & 3 deletions
diff --git a/‎coderd/database/queries/prebuilds.sql
Lines changed: 1 addition & 3 deletions b/‎coderd/database/queries/prebuilds.sql
Lines changed: 1 addition & 3 deletions
@@ -15,6 +15,7 @@ import (
 	"github.com/stretchr/testify/require"
 
 	"cdr.dev/slog/sloggers/slogtest"
+
 	"github.com/coder/coder/v2/coderd/coderdtest"
 	"github.com/coder/coder/v2/coderd/database"
 	"github.com/coder/coder/v2/coderd/database/db2sdk"
@@ -3474,6 +3475,5 @@ func TestOrganizationDeleteTrigger(t *testing.T) {
 
 func requireUsersMatch(t testing.TB, expected []database.User, found []database.GetUsersRow, msg string) {
 	t.Helper()
-	foundUsers := database.ConvertUserRows(found)
-	require.ElementsMatch(t, expected, foundUsers, msg)
+	require.ElementsMatch(t, expected, database.ConvertUserRows(found), msg)
 }
@@ -15,7 +15,6 @@ FROM workspace_prebuilds p
 		 LEFT JOIN template_version_presets tvp_curr
 				   ON tvp_curr.id = p.current_preset_id -- See https://github.com/coder/internal/issues/398.
 WHERE (b.transition = 'start'::workspace_transition
-	-- Jobs that are not in terminal states.
 	AND pj.job_status = 'succeeded'::provisioner_job_status);
 
 -- name: GetTemplatePresetsWithPrebuilds :many
@@ -79,7 +78,6 @@ WHERE lb.rn <= lb.desired_instances -- Fetch the last N builds, where N is the n
 GROUP BY lb.template_version_id, lb.preset_id, lb.job_status;
 
 -- name: ClaimPrebuild :one
--- TODO: rewrite to use named CTE instead?
 UPDATE workspaces w
 SET owner_id   = @new_user_id::uuid,
 	name       = @new_name::text,
@@ -95,7 +93,7 @@ WHERE w.id IN (SELECT p.id
 				 AND b.template_version_preset_id = @preset_id::uuid
 				 AND p.lifecycle_state = 'ready'::workspace_agent_lifecycle_state
 			   ORDER BY random()
-			   LIMIT 1 FOR UPDATE OF p SKIP LOCKED)
+			   LIMIT 1 FOR UPDATE OF p SKIP LOCKED) -- Ensure that a concurrent request will not select the same prebuild.
 RETURNING w.id, w.name;
 
 -- name: InsertPresetPrebuild :one