Data explorer shows not actual(cached?) content of file when saving different tables with the same filename.

[ivan-balashov]

System details:

macos 13.5.1 (22G90)

Positron and OS details:

Версия: Positron Version: 2025.01.0 (Universal) build 39
Code - OSS Version: 1.93.0
Commit: c7ef34f
Date: 2024-12-09T02:49:50.608Z
Фиксация: 30.4.0
Дата: 124.0.6367.243
Electron: 20.15.1
ElectronBuildId: 12.4.254.20-electron.0
Chromium: Darwin x64 22.6.0
Node.js: undefined
V8: undefined
ОС: undefined

Interpreter details:

Does not matter
tests with different R-4* and python 3-9.-3.12. interpreters

Describe the issue:

Data explorer shows not actual(cached?) content of file when saving different tables with the same filename.

I've saving file (e.g. 'test.tsv') from R or python (doesnt matter) and then click on it so it opens in Data Explorer.
I am closing the Data Explorer tab.
After this, I've saving another dataframe with other columns using the same filename ('test.tsv') and when I am clicking on it the Data explorer shows to me the old file content while file is changed;

If I an opening this file using 'open with..' text editor - it shows new content, sofile is really changed while Data explorer could not track it and shows not actual content(I assume it is due to cache invalidation problem);

Steps to reproduce the issue:

I've saving file (e.g. 'test.tsv') from R or python (doesnt matter) and then click on it so it opens in Data Explorer.
I am closing the Data Explorer tab.
After this, I've saving another dataframe with other columns using the same filename ('test.tsv') and when I am clicking on it the Data explorer shows to me the old file content while file is changed;

If I an opening this file using 'open with..' text editor - it shows new content, so file is really changed while Data explorer could not track it and shows not actual content(I assume it is due to cache invalidation problem);

Expected or desired behavior:

Data Explorer should show actual file content, not cached;

Were there any error messages in the UI, Output panel, or Developer Tools console?

Nothing

Video of bug

2024-12-25.15.26.28.mov

[juliasilge]

I believe this is the same as #5551 which was solved by #5651. This fix is not yet in a publicly available build but should be later this week! Keep an eye out for a new release at https://github.com/posit-dev/positron/releases in the next couple of days!

(For internal folks, this fix is in builds 2025.01.0-50 and later.)

EDIT: NOPE, this was wrong. This is a different bug that I can reproduce in the very latest builds.

Thank you for the report, @ivan-balashov!

Here are some reproducible steps:

• Run iris |> readr::write_csv("test.csv")
• Click on the file in the File Explorer to open it up; note that we correctly see the iris data
• Run mtcars |> readr::write_csv("test.csv")
• Again click on the file in the File Explorer to open it up; note that we incorrectly still see the iris data

You can do readr::read_csv("test.csv") to see that the file is in fact updated.

[juliasilge]

If you run mtcars |> readr::write_csv("test.csv") while the Data Explorer tab is open, it correctly updates. It is only if the Data Explorer tab is closed that we see the bug.

[wesm]

Thanks for the investigation -- I'm having a look at this. File updates with the DuckDB backend are a bit finicky