Import SQLite 3.7.6.3.

third_party/sqlite/src/test/fts3b.test

 # 2007 August 20
 #
 # 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 190 matching lines @@
 } {{still testing}}
 
 # If an insert tries to set both docid and rowid, require an error.
 do_test fts3b-4.8 {
   catchsql {
     INSERT INTO t4 (rowid, docid, c) VALUES (14, 15, 'bad test');
     SELECT * FROM t4 WHERE docid = 14;
   }
 } {1 {SQL logic error or missing database}}
 
-# Don't allow update of docid, to match rowid behaviour.
 do_test fts3b-4.9 {
-  catchsql {
+  execsql { SELECT docid FROM t4 WHERE t4 MATCH 'testing' }
+} {12}
+do_test fts3b-4.10 {
+  execsql { 
     UPDATE t4 SET docid = 14 WHERE docid = 12;
+    SELECT docid FROM t4 WHERE t4 MATCH 'testing';
   }
-} {1 {SQL logic error or missing database}}
+} {14}
+do_test fts3b-4.11 {
+  execsql { SELECT * FROM t4 WHERE rowid = 14; }
+} {{still testing}}
+do_test fts3b-4.12 {
+  execsql { SELECT * FROM t4 WHERE rowid = 12; }
+} {}
+do_test fts3b-4.13 {
+  execsql { SELECT docid FROM t4 WHERE t4 MATCH 'still'; }
+} {14}
 
 finish_test