sqlite> .header the a team is back
sqlite> .backup main foo surplus arguments
sqlite> .bail says this takes on or off
sqlite> .databases doesn't care either
sqlite> .dump does not care if the tables do not exist or even are the number 3
sqlite> .echo are the ghostbusters out there?
sqlite> .exit with code 22

(I got bored having illustrated the point :-)

rogerb added on 2009-10-01 02:04:07:
Another example is in parsing the .mode argument. You can supply any substring of a valid mode which doesn't appear to be the intention of the code (why check for "line" and "lines", "column" or "columns") or the error message.

sqlite> .mode ddd
mode should be one of: column csv html insert line list tabs tcl
sqlite> .mode col
sqlite> .mode c
sqlite> .mode ht
sqlite> .mode t

The actual mode that gets selected is based on the first match in the C code (eg "line" is checked for before "list" and "tcl" is checked before "tabs").

Suggested code fix is to change the strncmps to a simple strcmp

shane added on 2009-11-06 17:22:36:
Updated shell.c to improve "dot" command argument handling. Added some basic tests to shell1.test to verify this.

Check-in 9fb6991933.