Import SQLite 3.8.7.4.

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

 # 2010 August 28
 #
 # 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.
 #
 #***********************************************************************
 # This file contains tests for the r-tree module. Specifically, it tests
 # that custom r-tree queries (geometry callbacks) work.
 # 
 
 if {![info exists testdir]} {
   set testdir [file join [file dirname [info script]] .. .. test]
 } 
 source $testdir/tester.tcl
 ifcapable !rtree { finish_test ; return }
+ifcapable rtree_int_only { finish_test; return }
 
 register_cube_geom db
 
 do_execsql_test rtree9-1.1 {
   CREATE VIRTUAL TABLE rt USING rtree(id, x1, x2, y1, y2, z1, z2);
   INSERT INTO rt VALUES(1, 1, 2, 1, 2, 1, 2);
 } {}
 do_execsql_test rtree9-1.2 {
   SELECT * FROM rt WHERE id MATCH cube(0, 0, 0, 2, 2, 2);
 } {1 1.0 2.0 1.0 2.0 1.0 2.0}
@@ skipping 86 matching lines @@
 do_execsql_test rtree9-5.2 {
   SELECT id FROM rt2 WHERE id MATCH circle(0.0, 0.0, 2.0);
 } {1 2 3 4 13 14 15 16 17}
 
 do_execsql_test rtree9-5.3 {
   UPDATE rt2 SET xmin=xmin+5, ymin=ymin+5, xmax=xmax+5, ymax=ymax+5;
   SELECT id FROM rt2 WHERE id MATCH circle(5.0, 5.0, 2.0);
 } {1 2 3 4 13 14 15 16 17}
 
 finish_test