Skip to content

DuckDB provider does not respect "File Search Path" #944

@Stan-RED

Description

@Stan-RED

Bug Description

DuckDB provider does not respect a connection setting for "File Search Path" when writing.

Repro steps

  1. Create connection for DuckDB, in-memory DB, "File Search Path" set to "Document Directory" (any other option is not working as well).
  2. Open any workspace, create a test.sql script there with something like "COPY (SELECT * FROM input.json) TO output.json.
  3. Create any JSONL file input.json in the same workspace.
  4. 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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions