1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
# name: test/sql/copy/csv/test_auto_detection_headers.test
# description: Test auto detection of headers
# group: [csv]
statement ok
PRAGMA enable_verification
query I
from read_csv('{DATA_DIR}/csv/headers/undetected_type.csv', delim = ';')
----
68,527.00
query I
from '{DATA_DIR}/csv/headers/all_varchar.csv'
----
Pedro
query II
from '{DATA_DIR}/csv/headers/single_line.csv'
----
query I
from '{DATA_DIR}/csv/headers/borked_type.csv'
----
02/01/2019
08//01/2019
# This should work even with only one line
query I
from '{DATA_DIR}/csv/headers/integer.csv'
----
32
|
