[sql] Import SQLite 3.17.0.

third_party/sqlite/src/ext/rtree/rtree3.test

 # 2008 Feb 19
 #
 # 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 29 matching lines @@
 #   rtree3-4b: OOM while deleting rows from a big table.
 #
 #   rtree3-5: Test OOM while inserting rows into a big table.
 #
 #   rtree3-6: Test OOM while deleting all rows of a table, one at a time.
 #
 #   rtree3-7: OOM during an ALTER TABLE RENAME TABLE command.
 #
 #   rtree3-8: Test OOM while registering the r-tree module with sqlite.
 #
-
+#   rtree3-11: OOM following a constraint failure
+#
 do_faultsim_test rtree3-1 -faults oom* -prep {
   faultsim_delete_and_reopen
 } -body {
   execsql {
     BEGIN TRANSACTION;
     CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
     INSERT INTO rt VALUES(NULL, 3, 5, 7, 9);
     INSERT INTO rt VALUES(NULL, 13, 15, 17, 19);
     DELETE FROM rt WHERE ii = 1;
     SELECT * FROM rt;
@@ skipping 166 matching lines @@
 do_faultsim_test rtree3-10 -faults oom-* -prep {
   faultsim_restore_and_reopen
   register_cube_geom db
   execsql { SELECT * FROM rt }
 } -body {
   execsql { SELECT ii FROM rt WHERE ii MATCH cube(4.5, 5.5, 6.5, 1, 1, 1) }
 } -test {
   faultsim_test_result {0 2}
 }
 
+
+do_test rtree3-11.prep {
+  faultsim_delete_and_reopen
+  execsql { 
+    CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
+    INSERT INTO rt VALUES(1, 2, 3, 4, 5);
+  }
+  faultsim_save_and_close
+} {}
+do_faultsim_test rtree3-10.1 -faults oom-* -prep {
+  faultsim_restore_and_reopen
+  execsql { SELECT * FROM rt }
+} -body {
+  execsql { INSERT INTO rt VALUES(1, 2, 3, 4, 5) }
+} -test {
+  faultsim_test_result {1 {UNIQUE constraint failed: rt.ii}} \
+                       {1 {constraint failed}}
+}
+do_faultsim_test rtree3-10.2 -faults oom-* -prep {
+  faultsim_restore_and_reopen
+  execsql { SELECT * FROM rt }
+} -body {
+  execsql { INSERT INTO rt VALUES(2, 2, 3, 5, 4) }
+} -test {
+  faultsim_test_result {1 {rtree constraint failed: rt.(y1<=y2)}} \
+                       {1 {constraint failed}}
+}
+
 finish_test