Remove intervals

Emyrk · Emyrk · commit 9e2002499ec9 · 2023-10-03T14:42:58.000-05:00
diff --git a/coderd/database/queries/workspaces.sql b/coderd/database/queries/workspaces.sql
@@ -135,21 +135,12 @@ WHERE
 			    -- 'running' states
 				WHEN @status = 'starting' THEN
 				    latest_build.job_status = 'running' AND
-					-- TODO: Should we drop the interval? Hung workspaces
-					-- should still be their last state?
-					latest_build.updated_at - INTERVAL '30 seconds' < NOW() AND
 					latest_build.transition = 'start'::workspace_transition
 				WHEN @status = 'stopping' THEN
 					latest_build.job_status = 'running' AND
-					-- TODO: Should we drop the interval? Hung workspaces
-					-- should still be their last state?
-					latest_build.updated_at - INTERVAL '30 seconds' < NOW() AND
 					latest_build.transition = 'stop'::workspace_transition
 				WHEN @status = 'deleting' THEN
 					latest_build.job_status = 'running' AND
-					-- TODO: Should we drop the interval? Hung workspaces
-					-- should still be their last state?
-					latest_build.updated_at - INTERVAL '30 seconds' < NOW() AND
 					latest_build.transition = 'delete'::workspace_transition
 
 			    -- 'succeeded' states
