[`node:sqlite`] `db.close()` does not actually close the database on Windows

[louislam]

Version: Deno 2.2.11 / rc / canary

After called db.close(), the databse filename is still used by Deno process on Windows, the database file cannot be removed due to this bug.

I guess it is related to db.prepare(...).

It is working fine on Linux and MacOS, but it is not working on Windows. For Node.js, it is working on Windows.

I also created a Github workflow.

Reproduce

1. On Windows
2. Run this test:
   https://github.com/louislam/deno-sqlite-reproduce/blob/test/native-sqlite_test.mjs

deno test --allow-all

Logs

GitHub Workflow:
https://github.com/louislam/deno-sqlite-reproduce/actions/runs/14632159547/job/41056379552

[louislam]

For reference, here is the Node.js test result with the same test file. They are all greens.

https://github.com/louislam/deno-sqlite-reproduce/actions/runs/14632388265/job/41056920174