[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/capi3.test

 # 2003 January 29
 #
 # 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.
 #
 #***********************************************************************
@@ skipping 154 matching lines @@
   sqlite3_errcode $db2
 } {SQLITE_OK}
 # FIX ME: Should test the db handle works.
 do_test capi3-3.2 {
   sqlite3_close $db2
 } {SQLITE_OK}
 do_test capi3-3.3 {
   catch {
     set db2 [sqlite3_open /bogus/path/test.db {}]
   }
-  sqlite3_extended_errcode $db2
-} {SQLITE_CANTOPEN}
+  set ::capi3_errno [sqlite3_system_errno $db2]
+  list [sqlite3_extended_errcode $db2] [expr {$::capi3_errno!=0}]
+} {SQLITE_CANTOPEN 1}
 do_test capi3-3.4 {
   sqlite3_errmsg $db2
 } {unable to open database file}
 do_test capi3-3.5 {
-  sqlite3_close $db2
-} {SQLITE_OK}
+  list [sqlite3_system_errno $db2] [sqlite3_close $db2]
+} [list $::capi3_errno SQLITE_OK]
 if {[clang_sanitize_address]==0} {
   do_test capi3-3.6.1-misuse {
     sqlite3_close $db2
   } {SQLITE_MISUSE}
   do_test capi3-3.6.2-misuse {
     sqlite3_errmsg $db2
   } {library routine called out of sequence}
   ifcapable {utf16} {
     do_test capi3-3.6.3-misuse {
       utf8 [sqlite3_errmsg16 $db2]
@@ skipping 725 matching lines @@
   catchsql {
     ROLLBACK;
   }
 } {0 {}}
 do_test capi3-11.9.3 {
   sqlite3_get_autocommit $DB
 } 1
 do_test capi3-11.10 {
   sqlite3_step $STMT
 } {SQLITE_ROW}
-ifcapable !autoreset {
-  # If SQLITE_OMIT_AUTORESET is defined, then the statement must be
-  # reset() before it can be passed to step() again.
-  do_test capi3-11.11a { sqlite3_step $STMT } {SQLITE_MISUSE}
-  do_test capi3-11.11b { sqlite3_reset $STMT } {SQLITE_ABORT}
-}
 do_test capi3-11.11 {
   sqlite3_step $STMT
 } {SQLITE_DONE}
-do_test capi3-11.12 {
-  sqlite3_step $STMT
-  sqlite3_step $STMT
-} {SQLITE_ROW}
+ifcapable !autoreset {
+  do_test capi3-11.12armor {
+    sqlite3_step $STMT
+    sqlite3_step $STMT
+  } {SQLITE_MISUSE}
+} else {
+  do_test capi3-11.12 {
+    sqlite3_step $STMT
+    sqlite3_step $STMT
+  } {SQLITE_ROW}
+}
 do_test capi3-11.13 {
   sqlite3_finalize $STMT
 } {SQLITE_OK}
 do_test capi3-11.14 {
   execsql {
     SELECT a FROM t2;
   }
 } {1 2}
 do_test capi3-11.14.1 {
   sqlite3_get_autocommit $DB
@@ skipping 305 matching lines @@
 if {![info exists tester_do_binarylog]} {
   db close
   vfs_unregister_all
   do_test capi3-20.1 {
     sqlite3_sleep 100
   } {0}
   vfs_reregister_all
 }
 
 finish_test