[sqlite] Shell not returning 1 on error

This error occurs in 3.8.6: $ echo 'foo' > /tmp/foo.sql $ sqlite3 /tmp/foo.db < /tmp/foo.sql Error: incomplete SQL: foo $ echo $? 0 0 is the return code from sqlite3 and this should instead return 1 since an error occured. shell.c:3644 if( nSql ){ if(

Re: [sqlite] unique constraints

The circumstances I was thinking about is if you had many tables with a column called 'name'. If each table had a different name for the constraint, then they could be differentiated. Otherwise, it would be nice to at least have the name of the table included in the error message. Also, I just

[sqlite] unique constraints

you are actully told the name of the unique constraint that failed: Error: near line 9: constraint uniq_name failed Since patching SQLite is beyond my programming capability, how would I best go about getting this added into the program? Thanks, -John Taylor ___