Commitf6b5d54

committed

clean up subquery

1 parent8b0c6a7 commitf6b5d54Copy full SHA for f6b5d54

File tree

+10

-12

lines changed

+10

-12

lines changed

Lines changed: 5 additions & 6 deletions

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

Lines changed: 5 additions & 6 deletions

Original file line number	Diff line number	Diff line change
`@@ -53,13 +53,12 @@ WITH`
`53`	`53`	`latest_prebuilds`
`54`	`54`	`AS (`
`55`	`55`	`SELECT`
`56`		`-workspaces.name,`
`57`		`-workspaces.template_id,`
`58`		`-latest_build.id,`
`59`	`56`	`latest_build.workspace_id,`
	`57`	`+workspaces.name,`
	`58`	`+workspaces.template_id,`
`60`	`59`	`latest_build.template_version_id,`
`61`		`-latest_build.job_id,`
`62`	`60`	`latest_build.template_version_preset_id,`
	`61`	`+latest_build.job_id,`
`63`	`62`	`latest_build.created_at`
`64`	`63`	`FROM`
`65`	`64`	`workspaces`
`@@ -101,7 +100,7 @@ WITH`
`101`	`100`	`AS (`
`102`	`101`	`SELECT`
`103`	`102`	`latest_prebuilds.workspace_idAS workspace_id,`
`104`		`- BOOL_AND(workspace_agents.lifecycle_state='ready'::workspace_agent_lifecycle_state)::booleanAS ready`
	`103`	`+COALESCE(BOOL_AND(workspace_agents.lifecycle_state='ready'::workspace_agent_lifecycle_state), false)::booleanAS ready`
`105`	`104`	`FROM`
`106`	`105`	`latest_prebuilds`
`107`	`106`	`LEFT JOIN workspace_resourcesON`
`@@ -117,7 +116,7 @@ SELECT`
`117`	`116`	`latest_prebuilds.template_id,`
`118`	`117`	`latest_prebuilds.template_version_id,`
`119`	`118`	`latest_prebuilds.template_version_preset_idAS current_preset_id,`
`120`		`-COALESCE(agent_readiness.ready, false)ASready,`
	`119`	`+agent_readiness.ready,`
`121`	`120`	`latest_prebuilds.created_at`
`122`	`121`	`FROM`
`123`	`122`	`latest_prebuilds`

Comments

(0)