What happens?

A change in behavior has been observed between DuckDB CLI versions 1.1.x and 1.2.1. Specifically, when using the sniff_csv function with ignore_errors=true, V1.2.1 detects quote and escape characters as single quotes ('), while V1.1.x correctly identifies them as double quotes (").

To Reproduce

select * from sniff_csv("master.csv", ignore_errors=true);
select * from sniff_csv("master.csv", ignore_errors=false);

master.csv

OS:

MAC OS

DuckDB Version:

1.2.1

DuckDB Client:

CLI

Hardware:

No response

Full Name:

Cherindranath Reddy

Affiliation:

Self-employed

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