Skip to content

Commit b25deaa

Browse files
authored
fix(coderd/database): fix limit in GetUserWorkspaceBuildParameters (#11954)
1 parent a34cada commit b25deaa

File tree

2 files changed

+48
-40
lines changed

2 files changed

+48
-40
lines changed

coderd/database/queries.sql.go

+24-19
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

coderd/database/queries/workspacebuildparameters.sql

+24-21
Original file line numberDiff line numberDiff line change
@@ -16,25 +16,28 @@ WHERE
1616
workspace_build_id = $1;
1717

1818
-- name: GetUserWorkspaceBuildParameters :many
19-
-- name: GetUserWorkspaceBuildParameters :many
20-
SELECT DISTINCT ON (tvp.name)
21-
tvp.name,
22-
wbp.value
23-
FROM
24-
workspace_build_parameters wbp
25-
JOIN
26-
workspace_builds wb ON wb.id = wbp.workspace_build_id
27-
JOIN
28-
workspaces w ON w.id = wb.workspace_id
29-
JOIN
30-
template_version_parameters tvp ON tvp.template_version_id = wb.template_version_id
31-
WHERE
32-
w.owner_id = $1
33-
AND wb.transition = 'start'
34-
AND w.template_id = $2
35-
AND tvp.ephemeral = false
36-
AND tvp.name = wbp.name
37-
ORDER BY
38-
tvp.name, wb.created_at DESC
19+
SELECT name, value
20+
FROM (
21+
SELECT DISTINCT ON (tvp.name)
22+
tvp.name,
23+
wbp.value,
24+
wb.created_at
25+
FROM
26+
workspace_build_parameters wbp
27+
JOIN
28+
workspace_builds wb ON wb.id = wbp.workspace_build_id
29+
JOIN
30+
workspaces w ON w.id = wb.workspace_id
31+
JOIN
32+
template_version_parameters tvp ON tvp.template_version_id = wb.template_version_id
33+
WHERE
34+
w.owner_id = $1
35+
AND wb.transition = 'start'
36+
AND w.template_id = $2
37+
AND tvp.ephemeral = false
38+
AND tvp.name = wbp.name
39+
ORDER BY
40+
tvp.name, wb.created_at DESC
41+
) q1
42+
ORDER BY created_at DESC, name
3943
LIMIT 100;
40-

0 commit comments

Comments
 (0)