What happens?

Differently from parquet, exporting with CSV doesn't respect the option FILE_SIZE_BYTES, it still exports a single .csv document with the whole content, regardless of the limit given.

To Reproduce

observed with the python client

OS:

linux x86_64

DuckDB Version:

1.3.0

DuckDB Client:

python

Hardware:

No response

Full Name:

Dean De Leo

Affiliation:

RelationalAI

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

I have tested with a stable release

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 (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

• Yes, I have