Skip to content

Commit e8aa9ac

Browse files
committed
fix query to not limit
1 parent ca5b504 commit e8aa9ac

File tree

2 files changed

+3
-7
lines changed

2 files changed

+3
-7
lines changed

coderd/database/queries.sql.go

Lines changed: 1 addition & 3 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

coderd/database/queries/organizationmembers.sql

Lines changed: 2 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -14,14 +14,12 @@ WHERE
1414
organization_id = @organization_id
1515
ELSE true
1616
END
17-
-- Filter by organization id
17+
-- Filter by user id
1818
AND CASE
1919
WHEN @user_id :: uuid != '00000000-0000-0000-0000-000000000000'::uuid THEN
2020
user_id = @user_id
2121
ELSE true
22-
END
23-
LIMIT
24-
1;
22+
END;
2523

2624
-- name: InsertOrganizationMember :one
2725
INSERT INTO

0 commit comments

Comments
 (0)