Commitb4838dc

committed

use lateral subquery

1 parent07b3e9b commitb4838dcCopy full SHA for b4838dc

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
`@@ -711,14 +711,15 @@ LEFT JOIN LATERAL (`
`711`	`711`	`ORDER BY build_numberDESC`
`712`	`712`	`LIMIT1`
`713`	`713`	`) latest_buildON true`
`714`		`-LEFT JOIN (`
	`714`	`+LEFT JOINLATERAL(`
`715`	`715`	`SELECT`
`716`	`716`	`workspace_agents.idas agent_id,`
`717`	`717`	`workspace_agents.nameas agent_name,`
`718`	`718`	`job_id`
`719`	`719`	`FROM workspace_resources`
`720`	`720`	`JOIN workspace_agentsONworkspace_agents.resource_id=workspace_resources.id`
`721`		`-) resourcesONresources.job_id=latest_build.job_id`
	`721`	`+WHERE job_id=latest_build.job_id`
	`722`	`+) resourcesON true`
`722`	`723`	`WHERE`
`723`	`724`	`-- Filter by owner_id`
`724`	`725`	`workspaces.owner_id= @owner_id :: uuid`

Comments

(0)