dentiny

Hi @rustyconover / @lnkuiper , I made a [PR](https://github.com/duckdb/duckdb/pull/20062) related to this issue, happy to discuss, thanks!

Thanks for the report! But somehow I cannot repro it ```sh [~/duckdb] (main) vscode@9a5948bd4884$ docker run --rm -it -v "$(pwd):/workspace" -w /workspace duckdb/duckdb Unable to find image 'duckdb/duckdb:latest' locally latest:...

Do you mind showing me the duckdb image tag? Not sure if it's the same for both of us. I confirm I'm also experimenting on linux-arm64

> i am not able to reproduce this either. But i think its some. combination of disabling some cache configuration which is causing this issue. I remember disabling default duckdb...

> i thought it is on by default too for Iceberg and delta as the data does not change for a specific version of the table ? Yes I believe...

> Switching the default would apply also to local files, and for those I am not sure if it's safe to skip validation (or turned around: we properly invalidate cache...

Speaking of which, I suspect we could have double caching for local filesystem / caching filesystem: https://github.com/duckdb/duckdb/discussions/19889

Discussed offline: Carlo's suggestion we could make boolean value into an enum, say, - validation (default) - no validation for remote only - no validation CC @lnkuiper

Error log ```sh ==================================================== ================ FAILURES SUMMARY ================ ==================================================== 1. D:/a/duckdb/duckdb/build/release/_deps/httpfs_extension_fc-src/test/sql/storage/encryption/temp_files/encrypted_out_of_core.test_slow:39 ================================================================================ Query unexpectedly failed! (D:/a/duckdb/duckdb/build/release/_deps/httpfs_extension_fc-src/test/sql/storage/encryption/temp_files/encrypted_out_of_core.test_slow:39)! ================================================================================ CREATE OR REPLACE TEMPORARY TABLE ans as select l1.*, l1.* from lineitem1 l1...

Yes, this is something I've considered but didn't implement: https://github.com/dentiny/duck-read-cache-fs/issues/257 - I'm aware duckdb external file cache does [validation](https://github.com/duckdb/duckdb/blob/bc4e384cea29a5aea6983c4f0707edc9515f53e2/src/storage/external_file_cache.cpp#L76-L96) by default, and provides [internal option](https://github.com/duckdb/ducklake/blob/51bfd079001964d431d592bbac2a351ad785e52a/src/storage/ducklake_multi_file_list.cpp#L351) to skip - I understand...