.cursor() loses schema information #162

What happens?

Whenever .cursor is called the description says Create a duplicate of the current connection however it actually losses the relevant schema information and instead switches to main

To Reproduce

con = duckdb.connect()
con.execute("CREATE SCHEMA IF NOT EXISTS other_schema")
con.execute("USE other_schema")
print(con.cursor().execute("SELECT current_schema()").fetchone())

OS:

Linux x86_64

DuckDB Package Version:

1.4.0

Python Version:

3.11.9

Full Name:

Julian Meyers

Affiliation:

Independent

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have not tested with any build

Did you include all relevant data sets for reproducing the issue?

Not applicable - the reproduction does not require a data set

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant configuration to reproduce the issue?

• Yes, I have