fix job acquisition for untagged provisioners

SasSwart · SasSwart · commit 5941dc3203c9 · 2024-11-12T10:51:44.000Z
diff --git a/coderd/database/migrations/000274_check_tags.up.sql b/coderd/database/migrations/000274_check_tags.up.sql
@@ -7,7 +7,8 @@ CREATE OR REPLACE FUNCTION tags_compatible(subset_tags tags, superset_tags tags)
 RETURNS boolean as $$
 BEGIN
 	RETURN CASE
-		WHEN superset_tags :: jsonb = '{"scope": "organization", "owner": ""}' :: jsonb
+		-- Special case for untagged provisioners
+		WHEN subset_tags :: jsonb = '{"scope": "organization", "owner": ""}' :: jsonb
 		THEN subset_tags = superset_tags
 		ELSE subset_tags :: jsonb <@ superset_tags :: jsonb
 	END;
