[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/incrblob4.test

 # 2012 March 23
 #
 # 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 68 matching lines @@
   read $blob 10
 } {tttttttttt}
 
 do_test 3.3 {
   set new [string repeat % 900]
   execsql { UPDATE t1 SET v = $new WHERE k = 20 }
   execsql { DELETE FROM t1 WHERE k=19 }
   execsql { INSERT INTO t1(v) VALUES($new) }
 } {}
 
+#-------------------------------------------------------------------------
+# Test that it is not possible to DROP a table with an incremental blob
+# cursor open on it.
+#
+do_execsql_test 4.1 {
+  CREATE TABLE t2(a INTEGER PRIMARY KEY, b);
+  INSERT INTO t2 VALUES(456, '0123456789');
+}
+do_test 4.2 {
+  set blob [db incrblob -readonly t2 b 456]
+  read $blob 5
+} {01234}
+do_catchsql_test 4.3 {
+  DROP TABLE t2
+} {1 {database table is locked}}
+do_test 4.4 {
+  sqlite3_extended_errcode db
+} {SQLITE_LOCKED}
+close $blob
+
 finish_test