[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/shell2.test

 # 2009 Nov 11
 #
 # The author disclaims copyright to this source code.  In place of
 # a legal notice, here is a blessing:
 #
 #    May you do good and not evil.
 #    May you find forgiveness for yourself and forgive others.
 #    May you share freely, never taking more than you give.
 #
 #***********************************************************************
 #
 # The focus of this file is testing the CLI shell tool.
 #
 # $Id: shell2.test,v 1.7 2009/07/17 16:54:48 shaneh Exp $
 #
 
 # Test plan:
 #
 #   shell2-1.*: Misc. test of various tickets and reported errors.
 #
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
-if {$tcl_platform(platform)=="windows"} {
-  set CLI "sqlite3.exe"
-} else {
-  set CLI "./sqlite3"
-}
-if {![file executable $CLI]} {
-  finish_test
-  return
-}
+set CLI [test_find_cli]
 db close
 forcedelete test.db test.db-journal test.db-wal
 sqlite3 db test.db
 
 
 #----------------------------------------------------------------------------
 #   shell2-1.*: Misc. test of various tickets and reported errors.
 #
 
 # Batch mode not creating databases.  
 # Reported on mailing list by Ken Zalewski.
 # Ticket [aeff892c57].
 do_test shell2-1.1.1 {
   forcedelete foo.db
   set rc [ catchcmd "-batch foo.db" "CREATE TABLE t1(a);" ]
   set fexist [file exist foo.db]
   list $rc $fexist
 } {{0 {}} 1}
 
 # Shell silently ignores extra parameters.
 # Ticket [f5cb008a65].
 do_test shell2-1.2.1 {
-  set rc [catch { eval exec $CLI \":memory:\" \"select 3\" \"select 4\" } msg]
+  set rc [catch { eval exec $CLI \":memory:\" \"select+3\" \"select+4\" } msg]
   list $rc $msg
 } {0 {3
 4}}
 
 # Test a problem reported on the mailing list. The shell was at one point
 # returning the generic SQLITE_ERROR message ("SQL error or missing database")
 # instead of the "too many levels..." message in the test below.
 #
 do_test shell2-1.3 {
   catchcmd "-batch test.db" {
@@ skipping 125 matching lines @@
 a
 1
 2
 SELECT * FROM foo2;
 b
 1
 2
 }}
 
 finish_test