Commitab80dc0

committed

awww yiss

1 parentbf85f58 commitab80dc0Copy full SHA for ab80dc0

File tree

+18

-14

lines changed

+18

-14

lines changed

Lines changed: 9 additions & 7 deletions

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

Lines changed: 9 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -100,16 +100,18 @@ WITH`
`100`	`100`	`ready_agents`
`101`	`101`	`AS (`
`102`	`102`	`SELECT`
`103`		`-workspace_resources.job_id,`
	`103`	`+latest_prebuilds.job_id,`
`104`	`104`	`BOOL_AND(workspace_agents.lifecycle_state='ready'::workspace_agent_lifecycle_state)::booleanAS ready`
`105`	`105`	`FROM`
`106`		`- workspace_resources`
`107`		`-JOIN workspace_agentsON`
`108`		`-workspace_agents.resource_id=workspace_resources.id`
`109`		`-WHERE`
`110`		`-workspace_agents.deleted= false`
	`106`	`+ latest_prebuilds`
	`107`	`+JOIN workspace_resourcesON`
	`108`	`+workspace_resources.job_id=latest_prebuilds.job_id`
	`109`	`+JOIN workspace_agentsON`
	`110`	`+workspace_agents.resource_id=workspace_resources.id`
	`111`	`+WHERE`
	`112`	`+workspace_agents.deleted= false`
`111`	`113`	`GROUP BY`
`112`		`-workspace_resources.job_id`
	`114`	`+latest_prebuilds.job_id`
`113`	`115`	`)`
`114`	`116`	`SELECT`
`115`	`117`	`latest_prebuilds.workspace_idAS id,`

Comments

(0)