fix: use correct empty uuids (#4917)

coadler · web-flow · commit 65ffa20ba292 · 2022-11-06T16:49:43.000-06:00
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/auditlogs.sql b/coderd/database/queries/auditlogs.sql
@@ -22,7 +22,7 @@ WHERE
 	END
 	-- Filter resource_id
 	AND CASE
-		WHEN @resource_id :: uuid != '00000000-00000000-00000000-00000000' THEN
+		WHEN @resource_id :: uuid != '00000000-0000-0000-0000-000000000000'::uuid THEN
 			resource_id = @resource_id
 		ELSE true
 	END
@@ -83,7 +83,7 @@ WHERE
 	END
 	-- Filter resource_id
 	AND CASE
-		WHEN @resource_id :: uuid != '00000000-00000000-00000000-00000000' THEN
+		WHEN @resource_id :: uuid != '00000000-0000-0000-0000-000000000000'::uuid THEN
 			resource_id = @resource_id
 		ELSE true
 	END
diff --git a/coderd/database/queries/templates.sql b/coderd/database/queries/templates.sql
@@ -18,7 +18,7 @@ WHERE
 	templates.deleted = @deleted
 	-- Filter by organization_id
 	AND CASE
-		WHEN @organization_id :: uuid != '00000000-00000000-00000000-00000000' THEN
+		WHEN @organization_id :: uuid != '00000000-0000-0000-0000-000000000000'::uuid THEN
 			organization_id = @organization_id
 		ELSE true
 	END
diff --git a/coderd/database/queries/templateversions.sql b/coderd/database/queries/templateversions.sql
@@ -9,7 +9,7 @@ WHERE
 		-- This allows using the last element on a page as effectively a cursor.
 		-- This is an important option for scripts that need to paginate without
 		-- duplicating or missing data.
-		WHEN @after_id :: uuid != '00000000-00000000-00000000-00000000' THEN (
+		WHEN @after_id :: uuid != '00000000-0000-0000-0000-000000000000'::uuid THEN (
 			-- The pagination cursor is the last ID of the previous page.
 			-- The query is ordered by the created_at field, so select all
 			-- rows after the cursor.
diff --git a/coderd/database/queries/users.sql b/coderd/database/queries/users.sql
@@ -102,7 +102,7 @@ WHERE
 		-- This allows using the last element on a page as effectively a cursor.
 		-- This is an important option for scripts that need to paginate without
 		-- duplicating or missing data.
-		WHEN @after_id :: uuid != '00000000-00000000-00000000-00000000' THEN (
+		WHEN @after_id :: uuid != '00000000-0000-0000-0000-000000000000'::uuid THEN (
 			-- The pagination cursor is the last ID of the previous page.
 			-- The query is ordered by the created_at field, so select all
 			-- rows after the cursor.
diff --git a/coderd/database/queries/workspacebuilds.sql b/coderd/database/queries/workspacebuilds.sql
@@ -42,7 +42,7 @@ WHERE
 		-- This allows using the last element on a page as effectively a cursor.
 		-- This is an important option for scripts that need to paginate without
 		-- duplicating or missing data.
-		WHEN @after_id :: uuid != '00000000-00000000-00000000-00000000' THEN (
+		WHEN @after_id :: uuid != '00000000-0000-0000-0000-000000000000'::uuid THEN (
 			-- The pagination cursor is the last ID of the previous page.
 			-- The query is ordered by the build_number field, so select all
 			-- rows after the cursor.
diff --git a/coderd/database/queries/workspaces.sql b/coderd/database/queries/workspaces.sql
@@ -102,7 +102,7 @@ WHERE
 	END
 	-- Filter by owner_id
 	AND CASE
-		WHEN @owner_id :: uuid != '00000000-00000000-00000000-00000000' THEN
+		WHEN @owner_id :: uuid != '00000000-0000-0000-0000-000000000000'::uuid THEN
 			owner_id = @owner_id
 		ELSE true
 	END
@@ -240,7 +240,7 @@ WHERE
 	END
 	-- Filter by owner_id
 	AND CASE
-		WHEN @owner_id :: uuid != '00000000-00000000-00000000-00000000' THEN
+		WHEN @owner_id :: uuid != '00000000-0000-0000-0000-000000000000'::uuid THEN
 			owner_id = @owner_id
 		ELSE true
 	END
