Hello, May I suggest a patch ? -- shell.c 2014-05-26 18:51:40.000000000 +0200 +++ shell.orig.c 2014-05-26 18:50:37.000000000 +0200 @@ -1917,8 +1917,6 @@ if( c=='\n' ){ p->nLine++; if( p->n>0 && p->z[p->n-1]=='\r' ) p->n--; - }else if( !p->z && c==cSep ){ - csv_append_char(p, 0); } p->cTerm = c; }
Regards. On Sat, May 24, 2014 at 9:46 AM, gwenn <gwenn.k...@gmail.com> wrote: > Hello, > When the first value of the first line is empty, .import fails: > $ echo '|test' > ko.csv > $ echo '""|test' > ok.csv > $ sqlite3 > SQLite version 3.8.4.3 2014-04-03 16:53:12 > sqlite> .import ko.csv test > ko.csv: empty file > sqlite> .import ok.csv test > sqlite> > > An error happens also when the table already exists: > sqlite> create table test (id text, data test); > sqlite> .import ko.csv test > ko.csv:1: expected 2 columns but found 1 - extras ignored > sqlite> > > Maybe CSVReader.z should be pre-allocated ? > > Regards. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users