SQLite Forum

--skip option does not work correctly.
Login
I ran a little experiment. There is indeed an anomaly there:

```
▶▶▶ .shell cat a.csv
,,,
1,2,4,8
42,,,
,9,3,1
▶▶▶ create table a(x,y,z,w);
▶▶▶ .import -csv -skip 1 a.csv a
a.csv:1: expected 4 columns but found 3 - filling the rest with NULL
▶▶▶ .nullvalue ø
▶▶▶ select * from a;
x   y  z  w
--  -  -  -
          ø
1   2  4  8
42
    9  3  1
```

Notice that the first line got imported with three blanks and a null.

If I add an extra character to the first line, either a comma or something else, the error goes away.

Additionally, the error is still there if I replace the first line with `,a,b,c`. So it appears to be justy the initial comma that is problematic.