Fix sql comparisons

Emyrk · Emyrk · commit 4cc1822b7d82 · 2023-10-03T17:07:56.000-05:00
diff --git a/coderd/database/queries/workspaces.sql b/coderd/database/queries/workspaces.sql
@@ -127,36 +127,36 @@ WHERE
 	-- Optionally include deleted workspaces
 	workspaces.deleted = @deleted
 	AND CASE
-		WHEN @status :: text != '' THEN
+		WHEN @statu :: text != '' THEN
 			CASE
 			    -- Some workspace specific status refer to the transition
 			    -- type. By default, the standard provisioner job status
 			    -- search strings are supported.
 			    -- 'running' states
 				WHEN @status = 'starting' THEN
-				    latest_build.job_status = 'running' AND
+				    latest_build.job_status = 'running'::provisioner_job_status AND
 					latest_build.transition = 'start'::workspace_transition
 				WHEN @status = 'stopping' THEN
-					latest_build.job_status = 'running' AND
+					latest_build.job_status = 'running'::provisioner_job_status AND
 					latest_build.transition = 'stop'::workspace_transition
 				WHEN @status = 'deleting' THEN
 					latest_build.job_status = 'running' AND
 					latest_build.transition = 'delete'::workspace_transition
 
 			    -- 'succeeded' states
 			    WHEN @status = 'deleted' THEN
-			    	latest_build.job_status = 'succeeded' AND
+			    	latest_build.job_status = 'succeeded'::provisioner_job_status AND
 			    	latest_build.transition = 'delete'::workspace_transition
 				WHEN @status = 'stopped' THEN
-					latest_build.job_status = 'succeeded' AND
+					latest_build.job_status = 'succeeded'::provisioner_job_status AND
 					latest_build.transition = 'stop'::workspace_transition
 				WHEN @status = 'started' THEN
-					latest_build.job_status = 'succeeded' AND
+					latest_build.job_status = 'succeeded'::provisioner_job_status AND
 					latest_build.transition = 'start'::workspace_transition
 
 				WHEN @status != '' THEN
 				    -- By default just match the job status exactly
-			    	latest_build.job_status = @status
+			    	latest_build.job_status = @status::provisioner_job_status
 				ELSE
 					true
 			END
