Bug Description
DuckDB provider does not respect a connection setting for "File Search Path" when writing.
Repro steps
- Create connection for DuckDB, in-memory DB, "File Search Path" set to "Document Directory" (any other option is not working as well).
- Open any workspace, create a test.sql script there with something like "COPY (SELECT * FROM input.json) TO output.json.
- Create any JSONL file input.json in the same workspace.
- Run the script.
Expected Behavior
- Script will read input.json and write output.json to the same folder.
Actual Behavior
- Input file is successfully read, but output.json is in the "~\AppData\Local\Programs\Microsoft VS Code" folder.
- The same script executed in the same workspace via duckdb works in the expected manner.
Environment
- DBCode version: 1.21.3
- VS Code (or fork) version: 1.108.1
- OS: Windows 11 (10.0.26100.0)
- Database: DuckDB in-memory
- Connection: Direct
Bug Description
DuckDB provider does not respect a connection setting for "File Search Path" when writing.
Repro steps
Expected Behavior
Actual Behavior
Environment