1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
# name: test/sql/copy/csv/test_headers_12089.test
# description: Test that headers described on #12089 are properly parsed.
# group: [csv]
statement ok
PRAGMA enable_verification
query I
select columns FROM sniff_csv('{DATA_DIR}/csv/headers/escaped_quote.csv');
----
[{'name': Name, 'type': VARCHAR}, {'name': 'Escaped\'\'Quote', 'type': BIGINT}]
query I
select columns FROM sniff_csv('{DATA_DIR}/csv/headers/unescaped_quote.csv');
----
[{'name': Name, 'type': VARCHAR}, {'name': 'Unescaped\'Quote', 'type': BIGINT}]
|
