What happens?

When trying to visualize the Prompt in the call to sniff_csv, the output is invalid and truncated after comment='

To Reproduce

cat > test_prompt.csv <<EOF
a,b
1,"a"
2,"b"
EOF

cat test_prompt.csv 

a,b
1,"a"
2,"b"

duckdb -line -c "select Prompt from sniff_csv('test_prompt.csv')"

Prompt = FROM read_csv('test_prompt.csv', auto_detect=false, delim=',', quote='"', escape='"', new_line='\n', skip=0, comment='

OS:

ubuntu 20.04

DuckDB Version:

v1.1.0 fa5c2fe

DuckDB Client:

Duckdb CLI

Hardware:

No response

Full Name:

Florian Gaudin-Delrieu

Affiliation:

Fieldbox

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?

Yes

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