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/csv_null_byte.test
# description: Read a CSV with a null byte
# group: [csv]
statement ok
PRAGMA enable_verification
query III
select * from '{DATA_DIR}/csv/nullbyte.csv';
----
val1 val\02 val3
query III
select * from read_csv('{DATA_DIR}/csv/nullbyte.csv', columns={'col1': 'VARCHAR', 'col2': 'VARCHAR', 'col3': 'VARCHAR'}, delim='|');
----
val1 val\02 val3
query II
select * from '{DATA_DIR}/csv/nullbyte_header.csv';
----
val1 val2
query II
select * from read_csv('{DATA_DIR}/csv/nullbyte_header.csv', columns={'col1': 'VARCHAR', 'col2': 'VARCHAR'}, delim='|', header=False);
----
col1 col\02
val1 val2
query II
select * from read_csv('{DATA_DIR}/csv/nullbyte_header.csv', columns={'col1': 'VARCHAR', 'col2': 'VARCHAR'}, delim='|', header=True);
----
val1 val2
|
