Re: [sqlite] Small bug with .import shell command

2014-05-26 Thread gwenn
Hello, May I suggest a patch ? -- shell.c 2014-05-26 18:51:40.0 +0200 +++ shell.orig.c 2014-05-26 18:50:37.0 +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_cha

[sqlite] Small bug with .import shell command

2014-05-24 Thread gwenn
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 alre