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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
# name: test/sql/copy/csv/17738.test
# description: Test for issue #17738
# group: [csv]
statement ok
PRAGMA enable_verification
query I
FROM read_csv('{DATA_DIR}/csv/17738_rn.csv',header=False,skip=3, delim = ';');
----
xyz
lorem ipsum
NULL
NULL
John,Doe,120 jefferson st.,Riverside, NJ, 08075
Jack,McGinnis,220 hobo Av.,Phila, PA,09119
"John ""Da Man""",Repici,120 Jefferson St.,Riverside, NJ,08075
Stephen,Tyler,"7452 Terrace ""At the Plaza"" road",SomeTown,SD, 91234
,Blankman,,SomeTown, SD, 00298
"Joan ""the bone"", Anne",Jet,"9th, at Terrace plc",Desert City,CO,00123
query I
FROM read_csv('{DATA_DIR}/csv/17738.csv',header=False,skip=3);
----
xyz
lorem ipsum
NULL
NULL
John,Doe,120 jefferson st.,Riverside, NJ, 08075
Jack,McGinnis,220 hobo Av.,Phila, PA,09119
"John ""Da Man""",Repici,120 Jefferson St.,Riverside, NJ,08075
Stephen,Tyler,"7452 Terrace ""At the Plaza"" road",SomeTown,SD, 91234
,Blankman,,SomeTown, SD, 00298
"Joan ""the bone"", Anne",Jet,"9th, at Terrace plc",Desert City,CO,00123
query I
FROM read_csv('{DATA_DIR}/csv/17738.csv',header=False,skip=4);
----
lorem ipsum
NULL
NULL
John,Doe,120 jefferson st.,Riverside, NJ, 08075
Jack,McGinnis,220 hobo Av.,Phila, PA,09119
"John ""Da Man""",Repici,120 Jefferson St.,Riverside, NJ,08075
Stephen,Tyler,"7452 Terrace ""At the Plaza"" road",SomeTown,SD, 91234
,Blankman,,SomeTown, SD, 00298
"Joan ""the bone"", Anne",Jet,"9th, at Terrace plc",Desert City,CO,00123
query IIIIII
FROM read_csv('{DATA_DIR}/csv/17738.csv',header=False,skip=7);
----
John Doe 120 jefferson st. Riverside NJ 08075
Jack McGinnis 220 hobo Av. Phila PA 09119
John "Da Man" Repici 120 Jefferson St. Riverside NJ 08075
Stephen Tyler 7452 Terrace "At the Plaza" road SomeTown SD 91234
NULL Blankman NULL SomeTown SD 00298
Joan "the bone", Anne Jet 9th, at Terrace plc Desert City CO 00123
|
