### Body

We currently miss fsspec retrieval for providers and #36186 fixed compatibility issue with it, so we should likely add unit tests covering it.

### Committer

- [X] I acknowledge that I am a maintainer/committer of the Apache Airflow project.
#
#
from __future__ import annotations
import inspect
import logging
from typing import (
    TYPE_CHECKING,
    Callable,
    Mapping,
)
from fsspec.implementations.local import LocalFileSystem
from airflow.compat.functools import cache
from airflow.providers_manager import ProvidersManager
from airflow.stats import Stats
from airflow.utils.module_loading import import_string
if TYPE_CHECKING:
    from fsspec import AbstractFileSystem
    from airflow.io.typedef import Properties
log = logging.getLogger(__name__)
def _file(_: str | None, storage_options: Properties) -> LocalFileSystem: