A constraint doing its job is not an error. On Fri, Jun 7, 2019, 7:49 PM Faheem Mitha <fah...@faheem.info> wrote:
> > Hi, > > Consider the following shell script: > > rm -f empty.db empty.csv > echo "" > empty.csv > echo "a, b" >> empty.csv > sqlite3 empty.db \ > 'DROP TABLE IF EXISTS empty;' \ > '.mode csv' \ > 'CREATE TABLE IF NOT EXISTS empty(A, B NOT NULL);' \ > '.import empty.csv empty' '.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. Isn't that wrong? > > Regards, Faheem Mitha > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
