update the default value for when no tags are provided

SasSwart · SasSwart · commit 96b64f4f4c8c · 2024-11-12T09:53:58.000Z
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/provisionerdaemons.sql b/coderd/database/queries/provisionerdaemons.sql
@@ -14,7 +14,7 @@ WHERE
 	organization_id = @organization_id :: uuid
 	AND
 	-- adding support for searching by tags:
-	 (@tags :: tags = '{}' :: tags OR tags_compatible(@tags::tags, provisioner_daemons.tags::tags));
+	 (@tags :: tags = 'null' :: tags OR tags_compatible(@tags::tags, provisioner_daemons.tags::tags));
 
 -- name: DeleteOldProvisionerDaemons :exec
 -- Delete provisioner daemons that have been created at least a week ago
diff --git a/coderd/database/queries/provisionerjobs.sql b/coderd/database/queries/provisionerjobs.sql
@@ -22,7 +22,7 @@ WHERE
 			AND nested.organization_id = @organization_id
 			-- Ensure the caller has the correct provisioner.
 			AND nested.provisioner = ANY(@types :: provisioner_type [ ])
-			AND tags_compatible(@tags :: jsonb, nested.tags)
+			AND tags_compatible(nested.tags, @tags :: jsonb)
 		ORDER BY
 			nested.created_at
 		FOR UPDATE
