The CLI cannot open a duckdb database created in R using version 1.1.3 or 1.1.3-1

[BorgeJorge]

This is under windows 10, and the bug seems to have crept in after version 1.0.0 for R, since this isn't a problem using that version. So for example, after running:

library(duckdb) # 1.1.3 or 1.1.3-1
con <- dbConnect(duckdb(), dbdir = 'mydb.duckdb')
dbExecute(con, "create table test as select 1")
dbDisconnect(con, shutdown = TRUE)

This is what happens in the CLI when you try to open the database:

D .open mydb.duckdb
Error: unable to open database "mydb.duckdb": IO Error: Cannot open file "mydb.duckdb": Access is denied.

The database also can't be opened in DBeaver, but it remains openable in R, and is also openable in Python.

[krlmlr]

Thanks. What happens if you call gc() or restart the R session?