SQLite
View Ticket
Not logged in
Ticket UUID: eb620916be52995fd1ee03dd61d2ae04848570b6
Title: Shell doesn't print header if multiple statements on one line
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Shell Resolution: Fixed
Last Modified: 2010-01-18 18:16:31
Detected By: Structural_Testing
Version Found In: 3.6.18
Description & Comments:
If you have headers turned on and have multiple statements on one line then headers are only printed for the first statement.
sqlite> create table foo(x); create table bar(y); insert into foo values(1); insert into bar values(2);
sqlite> .header on
sqlite> select * from foo ; select * from bar;
x
1
2

The output should have included y before the row from bar (value 2).


rogerb added on 2009-09-29 04:17:25:
The same issue happens when echo is on. The entire line is printed rather than each statement as it is executed:

sqlite> .echo on
sqlite> select 3; select 4;
select 3; select 4;
3
4

I would expect:

sqlite> .echo on
sqlite> select 3; select 4;
select 3;
3
 select 4;
4

rogerb added on 2009-10-19 05:31:41:
Also http://www.sqlite.org/cvstrac/tktview?tn=2919


shane added on 2009-10-22 21:26:03:
Check-in 790402c150.


shane added on 2010-01-18 18:16:31:
Additional changes in check-in 7080ae3bc3.