-echo cmdline arg does not work

(1) By anonymous on 2023-02-25 13:46:27 [source]

Steps to reproduce:

$ sqlite3 test.db "create table test(text, priority INTEGER);"
$ sqlite3 test.db "insert into test values('hello world', 1);"
$ sqlite3 -echo test.db "select * from test;"

Expected result

The command prints both the query and the result:

select * from memos;
hello world|1

Actual result

The command prints just a result:

hello world|1

Additionals

Known affected: 3.40.1+

Known not affected: 3.35.5

Related: https://bugzilla.altlinux.org/45289

(2.1) By Larry Brasfield (larrybr) on 2023-02-25 15:23:03 edited from 2.0 in reply to 1 [link] [source]

Thanks for the report. This has been fixed.¹

^{^} If bad SQL is submitted as part of the invocation with -echo, it will be echoed even though this is new behavior since version 3.40.?. No need to report that; we do not consider error responses to require the same stability as we prefer for normal responses.