Skip to content

CSV read failure #18527

@ericemc3

Description

@ericemc3

What happens?

This is a real world csv file, with a first line to skip (a comment), and some varchar values enclosed in ""

Curiously, if i delete last line in the file (row 2048, which is identical to the previous one), it works.

To Reproduce

stats_3_muta_10_21.csv

from read_csv('stats_3_muta_10_21.csv');

Invalid Input Error:
Error when sniffing file "C:\...\stats_3_muta_10_21.csv".

OS:

WIn11

DuckDB Version:

1.3.2

DuckDB Client:

Java

Hardware:

No response

Full Name:

eric mauviere

Affiliation:

icem7

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?

No - Other reason (please specify in the issue body)

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions