Test failures unrelated @Mytherin

@Maxxen: I am not sure failure is unrelated, or at least I have not seen this fail elsewhere.

I think it's fine to merge and look at this on a side, but my theory is that some global CURL setting are conflicting between curl bundled with spatial (via GDAL) and curl bundled with httpfs.
That needs a second look.

EDIT: the test looks like:

statement ok
SET ca_cert_file = 'README.md';

statement error
FROM read_blob('https://duckdb.org/')
----
<REGEX>:.*IO Error.*SSL.*

where here it seems that ca_cert_file is somehow ignored.

@carlopi I thought it was a transient http issue. can you reproduce it? It was green on my local fork CI https://github.com/Maxxen/duckdb/actions/runs/21484736374

Discussed in the office with @Maxxen, I think path forward is merging both this PR AND #20746 together.

Then there are all goodies of this PR, and restoring CI to fully green.

Issue mentioned with ca_cert_file to be investigated on a side.

#20746 targets main, so if this PR breaks CI then that will not fix it. Is that meant to also target v1.5?

#20746 targets main, so if this PR breaks CI then that will not fix it. Is that meant to also target v1.5?

Indeed, fixed up, but needs to go through CI.

Thanks!