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 |