Hello!
I have tried this on a Debian Linux, and it works as expected. I’m thinking that this could be an issue specific to Windows. There seem to be similar issues with DuckDB 1.1 on Windows, this issue might be worth checking out. Perhaps this could help?