Commit14796a9

committed

use lateral subquery

1 parentf3d5ffe commit14796a9Copy full SHA for 14796a9

File tree

-4

lines changed

-4

lines changed

File renamed without changes.

File renamed without changes.

Lines changed: 3 additions & 2 deletions

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

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -708,14 +708,15 @@ LEFT JOIN LATERAL (`
`708`	`708`	`ORDER BY build_numberDESC`
`709`	`709`	`LIMIT1`
`710`	`710`	`) latest_buildON true`
`711`		`-LEFT JOIN (`
	`711`	`+LEFT JOINLATERAL(`
`712`	`712`	`SELECT`
`713`	`713`	`workspace_agents.idas agent_id,`
`714`	`714`	`workspace_agents.nameas agent_name,`
`715`	`715`	`job_id`
`716`	`716`	`FROM workspace_resources`
`717`	`717`	`JOIN workspace_agentsONworkspace_agents.resource_id=workspace_resources.id`
`718`		`-) resourcesONresources.job_id=latest_build.job_id`
	`718`	`+WHERE job_id=latest_build.job_id`
	`719`	`+) resourcesON true`
`719`	`720`	`WHERE`
`720`	`721`	`-- Filter by owner_id`
`721`	`722`	`workspaces.owner_id= @owner_id :: uuid`

Comments

(0)