[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/exists.test

 # 2011 April 9
 #
 # 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.
 #
 #***********************************************************************
 # This file implements regression tests for SQLite library.  The
 # focus of this file is testing the various schema modification statements
 # that feature "IF EXISTS" or "IF NOT EXISTS" clauses.
 #
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
 source $testdir/lock_common.tcl
 
 
 foreach jm {rollback wal} {
+  if {![wal_is_capable] && $jm=="wal"} continue
 
   set testprefix exists-$jm
 
   # This block of tests is targeted at CREATE XXX IF NOT EXISTS statements.
   #
   do_multiclient_test tn {
 
     # TABLE objects.
     #
     do_test 1.$tn.1.1 {
@@ skipping 157 matching lines @@
       sql1 { DROP TRIGGER IF EXISTS tr1 }
       sql2 { CREATE TRIGGER aux.tr1 AFTER INSERT ON t2 BEGIN SELECT 1; END }
       sql1 { DROP TRIGGER IF EXISTS tr1 }
       sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'trigger' }
     } {}
   }
 }
 
 
 finish_test