[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/sort2.test

 # 2014 March 25.
 #
 # 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 13 matching lines @@
 sqlite3 db test.db
 
 foreach {tn script} {
   1 { }
   2 {
     catch { db close }
     reset_db
     catch { db eval {PRAGMA threads=7} }
   }
 } {
-
   eval $script
 
   do_execsql_test $tn.1 {
     PRAGMA cache_size = 5;
     WITH r(x,y) AS (
       SELECT 1, randomblob(100)
       UNION ALL
       SELECT x+1, randomblob(100) FROM r
       LIMIT 100000
     )
@@ skipping 15 matching lines @@
   do_execsql_test $tn.2.2 {
     CREATE UNIQUE INDEX i1 ON t1(b, a);
   }
   
   do_execsql_test $tn.2.3 {
     CREATE UNIQUE INDEX i2 ON t1(a);
   }
   
   do_execsql_test $tn.2.4 { PRAGMA integrity_check } {ok}
   
-  do_execsql_test $tn.3 {
-    PRAGMA cache_size = 5;
-    WITH r(x,y) AS (
-      SELECT 1, randomblob(100)
-      UNION ALL
-      SELECT x+1, randomblob(100) FROM r
-      LIMIT 1000000
-    )
-    SELECT count(x), length(y) FROM r GROUP BY (x%5)
-  } {
-    200000 100 200000 100 200000 100 200000 100 200000 100
+  # Because it uses so much data, this test can take 12-13 seconds even on
+  # a modern workstation. So it is omitted from "veryquick" and other
+  # permutations.test tests.
+  if {[isquick]==0} {
+    do_execsql_test $tn.3 {
+      PRAGMA cache_size = 5;
+      WITH r(x,y) AS (
+          SELECT 1, randomblob(100)
+          UNION ALL
+          SELECT x+1, randomblob(100) FROM r
+          LIMIT 1000000
+          )
+        SELECT count(x), length(y) FROM r GROUP BY (x%5)
+    } {
+      200000 100 200000 100 200000 100 200000 100 200000 100
+    }
   }
 }
 
 finish_test