[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/fts4merge.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 37 matching lines @@
     do_execsql_test 1.2.$i.1 { INSERT INTO t1(t1) VALUES('merge=1') }
     do_test 1.2.$i.2 { fts3_integrity_check t1 } ok
     do_execsql_test 1.2.$i.3 { 
       SELECT docid FROM t1 WHERE t1 MATCH 'zero one two three'
     } {123 132 213 231 312 321}
   }
   
   do_execsql_test 1.3 { 
     SELECT level, group_concat(idx, ' ') FROM t1_segdir GROUP BY level 
   } {
-    0 {0 1 2 3} 
-    1 {0 1 2 3 4 5 6} 
     2 {0 1 2 3}
   }
   
   for {set i 0} {$i<100} {incr i} {
     do_execsql_test 1.4.$i { INSERT INTO t1(t1) VALUES('merge=1,4') }
     do_test 1.4.$i.2 { fts3_integrity_check t1 } ok
     do_execsql_test 1.4.$i.3 { 
       SELECT docid FROM t1 WHERE t1 MATCH 'zero one two three'
     } {123 132 213 231 312 321}
   }
   
   do_execsql_test 1.5 { 
     SELECT level, group_concat(idx, ' ') FROM t1_segdir GROUP BY level 
   } {
-    2 {0 1}
     3 0
   }
   
   #-------------------------------------------------------------------------
   # Test cases 2.* test that errors in the xxx part of the 'merge=xxx' are
   # handled correctly.
   #
   do_execsql_test 2.0 "CREATE VIRTUAL TABLE t2 USING $mod"
   
   foreach {tn arg} {
     1   {merge=abc}
     2   {merge=%%%}
     3   {merge=,}
     4   {merge=5,}
     5   {merge=6,%}
     6   {merge=6,six}
     7   {merge=6,1}
-    8   {merge=6,0}
   } {
     do_catchsql_test 2.$tn { 
       INSERT INTO t2(t2) VALUES($arg);
     } {1 {SQL logic error or missing database}}
   }
   
   #-------------------------------------------------------------------------
   # Test cases 3.*
   #
   do_test 3.0 { 
     reset_db
     execsql { PRAGMA page_size = 512 }
     fts3_build_db_2 -module $mod 30040 
   } {}
   do_test 3.1 { fts3_integrity_check t2 } {ok}
   
   do_execsql_test 3.2 { 
     SELECT level, group_concat(idx, ' ') FROM t2_segdir GROUP BY level 
   } {
     0 {0 1 2 3 4 5 6} 
     1 {0 1 2 3 4} 
     2 {0 1 2 3 4} 
     3 {0 1 2 3 4 5 6}
   }
   
   do_execsql_test 3.3 { 
     INSERT INTO t2(t2) VALUES('merge=1000000,2');
     SELECT level, group_concat(idx, ' ') FROM t2_segdir GROUP BY level 
   } {
-    0 0 
-    2 0
-    3 0 
     4 0
-    6 0
   }
   
   #-------------------------------------------------------------------------
   # Test cases 4.*
   #
   reset_db
   do_execsql_test 4.1 "
     PRAGMA page_size = 512;
     CREATE VIRTUAL TABLE t4 USING $mod;
     PRAGMA main.page_size;
@@ skipping 59 matching lines @@
     0 {0 1 2 3 4 5 6 7} 
     1 {0 1 2 3 4 5 6 7 8 9 10 11 12 13} 
     2 {0 1 2}
   }
   
   do_execsql_test 5.3 {
     INSERT INTO t1(t1) VALUES('merge=1,5');
     INSERT INTO t1(t1) VALUES('merge=1,5');
     SELECT level, group_concat(idx, ' ') FROM t1_segdir GROUP BY level;
   } {
-    0 {0 1 2}
     1 {0 1 2 3 4 5 6 7 8 9 10 11 12 13 14} 
     2 {0 1 2 3}
   }
   
-  do_execsql_test 5.4 {SELECT quote(value) from t1_stat WHERE rowid=1} {X'0105'}
+  do_execsql_test 5.4 {SELECT quote(value) from t1_stat WHERE rowid=1} {X'010F'}
   do_test 5.5 {
     foreach docid [execsql {SELECT docid FROM t1}] {
       execsql {INSERT INTO t1 SELECT * FROM t1 WHERE docid=$docid}
     }
   } {}
   
-  do_execsql_test 5.6 {SELECT quote(value) from t1_stat WHERE rowid=1} {X'0105'}
+  do_execsql_test 5.6 {SELECT quote(value) from t1_stat WHERE rowid=1} {X'010F'}
   
   do_execsql_test 5.7 {
     SELECT level, group_concat(idx, ' ') FROM t1_segdir GROUP BY level;
     SELECT quote(value) from t1_stat WHERE rowid=1;
   } {
-    0 {0 1 2 3 4 5 6 7 8 9 10} 
+    0 {0 1 2 3 4 5 6 7} 
     1 {0 1 2 3 4 5 6 7 8 9 10 11 12} 
-    2 {0 1 2 3 4 5 6 7}
-    X'0105'
+    2 {0 1 2 3 4 5 6 7} 
+    X'010F'
   }
   
   do_execsql_test 5.8 {
     INSERT INTO t1(t1) VALUES('merge=1,6');
     INSERT INTO t1(t1) VALUES('merge=1,6');
     SELECT level, group_concat(idx, ' ') FROM t1_segdir GROUP BY level;
     SELECT quote(value) from t1_stat WHERE rowid=1;
   } {
-    0 {0 1 2 3 4} 
     1 {0 1 2 3 4 5 6 7 8 9 10 11 12 13} 
-    2 {0 1 2 3 4 5 6 7 8} X'0106'
+    2 {0 1 2 3 4 5 6 7 8} X'010E'
   }
   
   do_test 5.8.1 { fts3_integrity_check t1 } ok
   
   do_test 5.9 {
     set L [expr 16*16*7 + 16*3 + 12]
     foreach docid [execsql {
         SELECT docid FROM t1 UNION ALL SELECT docid FROM t1 LIMIT $L
     }] {
       execsql {INSERT INTO t1 SELECT * FROM t1 WHERE docid=$docid}
     }
   } {}
   
   do_execsql_test 5.10 {
     SELECT level, group_concat(idx, ' ') FROM t1_segdir GROUP BY level;
     SELECT quote(value) from t1_stat WHERE rowid=1;
   } {
-    0 0 1 {0 1} 2 0 3 0 X'0106'
+    0 {0 1 2 3 4 5 6 7 8 9 10 11} 1 0 2 0 3 0 X'010E'
   }
   
   do_execsql_test 5.11 {
     INSERT INTO t1(t1) VALUES('merge=1,6');
     SELECT level, group_concat(idx, ' ') FROM t1_segdir GROUP BY level;
     SELECT quote(value) from t1_stat WHERE rowid=1;
   } {
-    0 0 1 {0 1} 2 0 3 0 X''
+    1 {0 1} 2 0 3 0 X'010E'
   }
   
   #-------------------------------------------------------------------------
   # Test cases 6.*
   #
   # At one point the following test caused an assert() to fail (because the
   # second 'merge=1,2' operation below actually "merges" a single input
   # segment, which was unexpected).
   #
   do_test 6.1 {
@@ skipping 57 matching lines @@
   } {0}
   do_test 7.5 {
     set x [db total_changes]
     execsql { INSERT INTO t1(t1) VALUES('merge=200,10') }
     expr { ([db total_changes] - $x)>1 }
   } {0}
 
 }
 
 finish_test