Ensure tmp files are cleaned up after tests in CI

### Is your feature request related to a problem or challenge?

As of the current main branch (commit#91c9d6f), some tmp files are created during testing but not deleted afterwards:
```bash
> git checkout 91c9d6f
> cargo test read_from_different_file_extension
> git status
Untracked files:
(use "git add ..." to include in what will be committed)
datafusion/core/output1.parquet
datafusion/core/output2.parquet.snappy
datafusion/core/output3.parquet.snappy.parquet
```

We can add some checks in CI to make sure no tmp files are created but not deleted during testing

### Describe the solution you'd like

Additional CI checks

### Describe alternatives you've considered

_No response_

### Additional context

_No response_

Reproduce the issue with `cargo test read_from_different_file_extension` at commit 91c9d6f, then inspect the generated files under `datafusion/core/`: `output1.parquet`, `output2.parquet.snappy`, and `output3.parquet.snappy.parquet`. Identify the CI check location and make the test run report leftover temporary files; done means the check catches untracked outputs without affecting clean tests.

Written by the indexing model from the issue text.