| OLD | NEW |
| 1 # 2010 August 28 | 1 # 2010 August 28 |
| 2 # | 2 # |
| 3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
| 4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
| 5 # | 5 # |
| 6 # May you do good and not evil. | 6 # May you do good and not evil. |
| 7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
| 8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
| 9 # | 9 # |
| 10 #*********************************************************************** | 10 #*********************************************************************** |
| (...skipping 69 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 80 (cube(5.5, 5.5, 5.5, 1, 1, 1) || X'1234567812345678') AS blob | 80 (cube(5.5, 5.5, 5.5, 1, 1, 1) || X'1234567812345678') AS blob |
| 81 ) | 81 ) |
| 82 } {1 {SQL logic error or missing database}} | 82 } {1 {SQL logic error or missing database}} |
| 83 | 83 |
| 84 | 84 |
| 85 #------------------------------------------------------------------------- | 85 #------------------------------------------------------------------------- |
| 86 # Test the example 2d "circle" geometry callback. | 86 # Test the example 2d "circle" geometry callback. |
| 87 # | 87 # |
| 88 register_circle_geom db | 88 register_circle_geom db |
| 89 | 89 |
| 90 breakpoint | |
| 91 do_execsql_test rtree9-5.1 { | 90 do_execsql_test rtree9-5.1 { |
| 92 CREATE VIRTUAL TABLE rt2 USING rtree(id, xmin, xmax, ymin, ymax); | 91 CREATE VIRTUAL TABLE rt2 USING rtree(id, xmin, xmax, ymin, ymax); |
| 93 | 92 |
| 94 INSERT INTO rt2 VALUES(1, 1, 2, 1, 2); | 93 INSERT INTO rt2 VALUES(1, 1, 2, 1, 2); |
| 95 INSERT INTO rt2 VALUES(2, 1, 2, -2, -1); | 94 INSERT INTO rt2 VALUES(2, 1, 2, -2, -1); |
| 96 INSERT INTO rt2 VALUES(3, -2, -1, -2, -1); | 95 INSERT INTO rt2 VALUES(3, -2, -1, -2, -1); |
| 97 INSERT INTO rt2 VALUES(4, -2, -1, 1, 2); | 96 INSERT INTO rt2 VALUES(4, -2, -1, 1, 2); |
| 98 | 97 |
| 99 INSERT INTO rt2 VALUES(5, 2, 3, 2, 3); | 98 INSERT INTO rt2 VALUES(5, 2, 3, 2, 3); |
| 100 INSERT INTO rt2 VALUES(6, 2, 3, -3, -2); | 99 INSERT INTO rt2 VALUES(6, 2, 3, -3, -2); |
| (...skipping 16 matching lines...) Expand all Loading... |
| 117 do_execsql_test rtree9-5.2 { | 116 do_execsql_test rtree9-5.2 { |
| 118 SELECT id FROM rt2 WHERE id MATCH circle(0.0, 0.0, 2.0); | 117 SELECT id FROM rt2 WHERE id MATCH circle(0.0, 0.0, 2.0); |
| 119 } {1 2 3 4 13 14 15 16 17} | 118 } {1 2 3 4 13 14 15 16 17} |
| 120 | 119 |
| 121 do_execsql_test rtree9-5.3 { | 120 do_execsql_test rtree9-5.3 { |
| 122 UPDATE rt2 SET xmin=xmin+5, ymin=ymin+5, xmax=xmax+5, ymax=ymax+5; | 121 UPDATE rt2 SET xmin=xmin+5, ymin=ymin+5, xmax=xmax+5, ymax=ymax+5; |
| 123 SELECT id FROM rt2 WHERE id MATCH circle(5.0, 5.0, 2.0); | 122 SELECT id FROM rt2 WHERE id MATCH circle(5.0, 5.0, 2.0); |
| 124 } {1 2 3 4 13 14 15 16 17} | 123 } {1 2 3 4 13 14 15 16 17} |
| 125 | 124 |
| 126 finish_test | 125 finish_test |
| OLD | NEW |