Import SQLite 3.10.2.

third_party/sqlite/src/test/sort4.test

 # 2014 May 6.
 #
 # 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 tests in this file are brute force tests of the multi-threaded
 # sorter.
 #
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
 set testprefix sort4
+db close
+sqlite3_shutdown
+sqlite3_config_pmasz 10
+sqlite3_initialize
+sqlite3 db test.db
+
 
 # Configure the sorter to use 3 background threads.
-db eval {PRAGMA threads=3}
+#
+# EVIDENCE-OF: R-19249-32353 SQLITE_LIMIT_WORKER_THREADS The maximum
+# number of auxiliary worker threads that a single prepared statement
+# may start.
+#
+do_test sort4-init001 {
+  db eval {PRAGMA threads=5}
+  sqlite3_limit db SQLITE_LIMIT_WORKER_THREADS -1
+} {5}
+do_test sort4-init002 {
+  sqlite3_limit db SQLITE_LIMIT_WORKER_THREADS 3
+  db eval {PRAGMA threads}
+} {3}
+
 
 # Minimum number of seconds to run for. If the value is 0, each test
 # is run exactly once. Otherwise, tests are repeated until the timeout
 # expires.
 set SORT4TIMEOUT 0
 if {[permutation] == "multithread"} { set SORT4TIMEOUT 300 }
 
 #--------------------------------------------------------------------
 # Set up a table "t1" containing $nRow rows. Each row contains also
 # contains blob fields that collectively contain at least $nPayload 
@@ skipping 147 matching lines @@
   do_sorter_test $t.6 -repeats 10 -rows 100000 -read 10 -payload 8
   do_sorter_test $t.7 -repeats 10 -rows 10000 -read 10000 -payload 8 -fakeheap 1
   do_sorter_test $t.8 -repeats 10 -rows 100000 -read 10000 -cachesize 250
 
   set iNow [clock_seconds]
   if {$iNow>=$iTimeLimit} break
   do_test "$testprefix-([expr $iTimeLimit-$iNow] seconds remain)" {} {}
 }
 
 finish_test