Re: [sqlite] Bug in sqlite3 (CLI, linux/Ubuntu)
On 30-3-2019 12:28, softw...@quantentunnel.de wrote: 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 abc0 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 ___ upgrade ? ~$ sqlite3 /tmp/test.db "CREATE TABLE test (col1); INSERT INTO test VALUES(1);" ~$ ~$ touch /tmp/test.init ~$ sqlite3 /tmp/test.db "SELECT * FROM test;" 2>/dev/null 1 ~$ ~$ ~$ sqlite3 -int /tmp/test.init /tmp/test.db "SELECT * FROM test;" 2>/dev/null ~$ ls -l /tmp total 16 -rw-r--r-- 1 luuk luuk 8192 Mar 30 17:18 test.db -rw-rw-rw- 1 luuk luuk 0 Mar 30 17:18 test.init ~$ sqlite3 -version 3.22.0 2018-01-22 18:45:57 0c55d179733b46d8d0ba4d88e01a25e10677046ee3da1d5b1581e86726f2alt1 ~$ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Bug in sqlite3 (CLI, linux/Ubuntu)
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 abc0 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
Re: [sqlite] Clear sqlite3 terminal enhancement
On 28-3-2019 14:42, Dominique Devienne wrote: On Thu, Mar 28, 2019 at 1:16 PM Clemens Ladisch wrote: Jeffrey Walton wrote: When working in the Linux terminal we can clear the scrollback with the 'clear' command; and we can delete all history and scrollback with the 'reset' command. I am not able to do the same within the sqlite3 terminal. Those are programs run from the shell. So you can use ".shell clear" or ".shell reset". Nice trick, thanks for sharing. `.shell cls` on Windows worked for me. --DD The 'reset' option is even shorter on Windows. Try ALT+F7 ;) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
