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
|
# name: test/sql/copy/csv/test_csv_no_trailing_newline.test
# description: Test CSV file without trailing newline
# group: [csv]
statement ok
PRAGMA enable_verification
# no newline at end of file with simple delimiter
# load CSV file into a table
statement ok
CREATE TABLE no_newline (a INTEGER, b INTEGER, c VARCHAR(10));
query I
COPY no_newline FROM '{DATA_DIR}/csv/test/no_newline.csv';
----
1024
query III
FROM read_csv('{DATA_DIR}/csv/test/no_newline_unicode.csv', delim= '🦆') limit 5;
----
0 0 test
1 1 test
2 2 test
3 3 test
4 4 test
|
