[sqlite] Failing SQLite .import returns exit status 0

2019-06-07 Thread Faheem Mitha
pty' '.exit' echo "error code is" $? This returns: sh sqlite_err.sh empty.csv:1: expected 2 columns but found 1 - filling the rest with NULL empty.csv:1: INSERT failed: NOT NULL constraint failed: empty.B error code is 0 There is an error, but the exit status is 0. I

[sqlite] CSV import does not handle fields with a comma surrounded by double

2019-05-21 Thread Faheem Mitha
Hi, I'm seeing the same bug reported here, in an issue from 2009, supposedly fixed in 2014. https://www.sqlite.org/src/tktview?name=c25aab7e7e with the title: The ".import" command does not parse CSV correctly. I'm using Debian buster, with SQLite version 3.27.2-2. Here is a simple