Dear colleagues I detected an unexpected behaviour in sqlite3 (CLI) that I consider a bug as it seems not documented.
When using an init file (even if an empty file), sqlite3 outputs an extra empty line to stdout. This messes up parsing of the sqlite3 output, as this line is not present in the absence of an init file: buero:~$ sqlite3 /tmp/test.db "CREATE TABLE test (col1); INSERT INTO test VALUES(1);" buero:~$ touch /tmp/test.init buero:~$ ls -l /tmp/test.* -rw-r----- 1 abc abc 2048 Mär 30 12:17 /tmp/test.db -rw-r----- 1 abc abc 0 Mär 30 12:17 /tmp/test.init buero:~$ sqlite3 /tmp/test.db "SELECT * FROM test;" 2>/dev/null 1 buero:~$ sqlite3 -init /tmp/test.init /tmp/test.db "SELECT * FROM test;" 2>/dev/null 1 buero:~$ My configuration buero:~$ sqlite3 --version 3.11.0 2016-02-15 17:29:24 3d862f207e3adc00f78066799ac5a8c282430a5f buero:~$ uname -a Linux buero 4.15.0-46-generic #49~16.04.1-Ubuntu SMP Tue Feb 12 17:45:24 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
