[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/corruptC.test

 # 2004 August 30
 #
 # 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 82 matching lines @@
   forcecopy test.bu test.db
 
   # insert corrupt byte(s)
   hexio_write test.db 2053 [format %02x 0x04]
 
   sqlite3 db test.db
   catchsql {PRAGMA integrity_check}
 } {1 {database disk image is malformed}}
 
 # test that a corrupt content offset size is handled (seed 5649)
+#
+# Update 2016-12-27:  As of check-in [0b86fbca66] "In sqlite3BtreeInsert() when
+# replacing a re-existing row, try to overwrite the cell directly rather than
+# deallocate and reallocate the cell" on 2016-12-09, this test case no longer
+# detects the offset size problem during the UPDATE.  We have to run a subsequent
+# integrity_check to see it.
 do_test corruptC-2.2 {
   db close
   forcecopy test.bu test.db
 
   # insert corrupt byte(s)
   hexio_write test.db 27   [format %02x 0x08]
   hexio_write test.db 233  [format %02x 0x6a]
   hexio_write test.db 328  [format %02x 0x67]
   hexio_write test.db 750  [format %02x 0x1f]
   hexio_write test.db 1132 [format %02x 0x52]
   hexio_write test.db 1133 [format %02x 0x84]
   hexio_write test.db 1220 [format %02x 0x01]
   hexio_write test.db 3688 [format %02x 0xc1]
   hexio_write test.db 3714 [format %02x 0x58]
   hexio_write test.db 3746 [format %02x 0x9a]
 
   sqlite3 db test.db
-  catchsql {UPDATE t1 SET y=1}
-} {1 {database disk image is malformed}}
+  db eval {UPDATE t1 SET y=1}
+  db eval {PRAGMA integrity_check}
+} {/Offset .* out of range/}
 
 # test that a corrupt free cell size is handled (seed 13329)
 do_test corruptC-2.3 {
   db close
   forcecopy test.bu test.db
 
   # insert corrupt byte(s)
   hexio_write test.db 1094 [format %02x 0x76]
 
   sqlite3 db test.db
@@ skipping 18 matching lines @@
   forcecopy test.bu test.db
 
   # insert corrupt byte(s)
   hexio_write test.db 3119 [format %02x 0xdf]
   hexio_write test.db 4073 [format %02x 0xbf]
 
   sqlite3 db test.db
   catchsql {BEGIN; UPDATE t2 SET y='abcdef-uvwxyz'; ROLLBACK;}
   catchsql {PRAGMA integrity_check}
 } {0 {{*** in database main ***
-Page 4: btreeInitPage() returns error code 11}}}
+On tree page 4 cell 19: Extends off end of page}}}
 
 # {0 {{*** in database main ***
 # Corruption detected in cell 710 on page 4
 # Multiple uses for byte 661 of page 4
 # Fragmented space is 249 byte reported as 21 on page 4}}}
 
 # test that a corrupt free cell size is handled (seed 169595)
 do_test corruptC-2.6 {
   db close
   forcecopy test.bu test.db
@@ skipping 240 matching lines @@
         set stats(ref)
       } {0}
     }
   }
   # end for i
 
 }
 # end for tn
 
 finish_test