What happens?

DuckDB 1.3 added the ability to query directly files with the CLI in #17415: . It works for the files with CSV extension. For the files with TSV extension:

duckdb phonelogs.tsv -c 'from phonelogs' returns error:

IO Error: The file "phonelogs.tsv" exists, but it is not a valid DuckDB database file!

When I change just the extension to CSV (the file content is still the same) it works:
duckdb phonelogs.csv -c 'from phonelogs'

The file phonelogs.tsv looks like this:

za období 01.06.2021 - 30.06.2021	207.6100
za období 01.07.2021 - 31.07.2021	342.8600
za období 01.08.2021 - 31.08.2021	203.00

To Reproduce

duckdb phonelogs.tsv -c 'from phonelogs'

OS:

Ubuntu 20.04, x86_64

DuckDB Version:

1.3.1

DuckDB Client:

Command Line Interface

Hardware:

No response

Full Name:

JaroFromel

Affiliation:

self

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