[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/fts4merge3.test

 # 2012 March 06
 #
 # 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 44 matching lines @@
     # Run some incr-merge operations on the db.
     for {set i 0} {$i<10} {incr i} {
       do_test 1.6.$i.1 { sql1 { INSERT INTO t2(t2) VALUES('merge=2,2') } } {}
       do_test 1.6.$i.2 { 
         sql2 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'" 
       } {1485}
     }
 
     do_test 1.7 { sql2 { 
       SELECT level, count(*) FROM t2_segdir GROUP BY level ORDER BY 1
-    } } [list  0 1  2 18  3 5]
+    } } {2 15 3 5}
 
     # Using the old connection, insert many rows. 
     do_test 1.8 {
       for {set i 0} {$i < 1500} {incr i} {
         sql2 "INSERT INTO t2 SELECT content FROM t2 WHERE docid = $i"
       }
     } {}
 
     do_test 1.9 { sql2 { 
       SELECT level, count(*) FROM t2_segdir GROUP BY level ORDER BY 1
-    } } [list  0 13  1 13  2 5  3 6]
+    } } [list  0 12  1 13  2 4  3 6]
 
     # Run a big incr-merge operation on the db.
     do_test 1.10 { sql1 { INSERT INTO t2(t2) VALUES('merge=2000,2') } } {}
     do_test 1.11 { 
       sql2 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'" 
     } {1485 21485}
 
     do_test 1.12 {
       for {set i 0} {$i < 1500} {incr i} {
         sql2 "INSERT INTO t2 SELECT content FROM t2 WHERE docid = $i"
       }
     } {}
     do_test 1.13 { 
       sql2 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'" 
     } {1485 21485 22985}
 
     do_test 1.14 { 
       sql2 "INSERT INTO t2(t2) VALUES('optimize')"
       sql2 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'" 
     } {1485 21485 22985}
 
     do_test 1.15 { sql2 { 
       SELECT level, count(*) FROM t2_segdir GROUP BY level ORDER BY 1
-    } } {6 1}
+    } } {4 1}
   }
 }
 
 
 finish_test