Commitc4316fd

committed

refactor(coderd/database): use job_status generated column

1 parent8b3446e commitc4316fdCopy full SHA for c4316fd

File tree

-8

lines changed

-8

lines changed

Lines changed: 1 addition & 4 deletions

Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

Lines changed: 1 addition & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -63,10 +63,7 @@ pending_jobs AS (`
`63`	`63`	`-- Step 2: Extract only pending jobs`
`64`	`64`	`SELECT*`
`65`	`65`	`FROM provisioner_jobs`
`66`		`-WHERE started_at ISNULL`
`67`		`-AND canceled_at ISNULL`
`68`		`-AND completed_at ISNULL`
`69`		`-AND error ISNULL`
	`66`	`+WHERE job_status='pending'`
`70`	`67`	`),`
`71`	`68`	`ranked_jobsAS (`
`72`	`69`	`-- Step 3: Rank only pending jobs based on provisioner availability`

Comments

(0)