Attaching DB via URL on Windows leads to "Cannot open file" error

[nikammerlaan]

When attempting to attach a database via an HTTP URL on Windows, DuckDB seems to interpret the URL as a file and then fails to open it. This issue was introduced between versions 1.2.2.0 and 1.3.0.0. Here is a repo that is able to reproduce the error:

https://github.com/nikammerlaan/duckdb-bug-repro

DuckdbBugRepro > test() FAILED
    java.sql.SQLException: IO Error: Cannot open file "http://localhost:56144/test-bucket/database.duckdb?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=minioadmin%2F20250712%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250712T203631Z&X-Amz-Expires=3600&X-Amz-SignedHeaders=host&X-Amz-Signature=c90c1d82b5c44409343a9b42f5e451304808d81035f1c1af8ef22cef8f9cb951": The system cannot find the path specified.
        at org.duckdb.DuckDBNative.duckdb_jdbc_execute(Native Method)
        at org.duckdb.DuckDBPreparedStatement.execute(DuckDBPreparedStatement.java:178)
        at org.duckdb.DuckDBPreparedStatement.execute(DuckDBPreparedStatement.java:155)
        at org.duckdb.DuckDBPreparedStatement.execute(DuckDBPreparedStatement.java:241)
        at DuckdbBugRepro.attachDatabaseFromHttpUrl(DuckdbBugRepro.java:80)
        at DuckdbBugRepro.test(DuckdbBugRepro.java:25)

[staticlibs]

@nikammerlaan

Hi, thanks for the report! Something is wrong here with path type detection. I wonder if running LOAD httpfs; before running ATTACH ... will make any difference?

[nikammerlaan]

Interesting! Running LOAD httpfs; prior does actually seem to work!