It seems that the `test_find_not_should_ignore_path` test has some dependency on side-effects from other tests. 

For example it failed here:

https://github.com/apache/airflow/pull/10983/checks?check_run_id=1127304894#step:6:1043

```
>       self.assertEqual(detected_files, should_not_ignore_files)
E       AssertionError: Items in the second set but not the first:
E       'test_load.py'
E       'test_load_sub1.py'
```

And re-running it in a clean system works just fine in the same combination of python/db.

**What you expected to happen**:

The test should clean up /restore everything it needs before running or a test that makes side-effects is found and fixed. 

For now I am moving the test to "heisentests with appropriate note.".

airflow/utils/file.py
"""
    If the path contains a folder with a .zip suffix, then
    the folder is treated as a zip archive and path to zip is returned.
    """
    _, archive, _ = ZIP_REGEX.search(fileloc).groups()
    if archive and zipfile.is_zipfile(archive):
        return archive
    else:
        return fileloc
def open_maybe_zipped(fileloc, mode='r'):
    """
    Opens the given file. If the path contains a folder with a .zip suffix, then
    the folder is treated as a zip archive, opening the file inside the archive.
    :return: a file object, as in `open`, or as in `ZipFile.open`.
    """
    _, archive, filename = ZIP_REGEX.search(fileloc).groups()
    if archive and zipfile.is_zipfile(archive):
        return zipfile.ZipFile(archive, mode=mode).open(filename)
    else:
        return open(fileloc, mode=mode)
def find_path_from_directory(