Lines Matching refs:r1
57 CREATE VIRTUAL TABLE r1 USING $module (id, x1, x2, y1, y2);
58 INSERT INTO r1 VALUES(1, 5, 5, 5, 5); -- 3
59 INSERT INTO r1 VALUES(2, 6, 6, 6, 6); -- 9
60 INSERT INTO r1 VALUES(3, 7, 7, 7, 7); -- 15
61 INSERT INTO r1 VALUES(4, 8, 8, 8, 8); -- 21
62 INSERT INTO r1 VALUES(5, 9, 9, 9, 9); -- 27
69 SELECT rtreecheck('r1')
78 SELECT rtreecheck('r1')
85 SELECT rtreecheck('r1')
92 SELECT rtreecheck('r1')
97 CREATE VIRTUAL TABLE r1 USING rtree_i32(id, x1, x2);
98 INSERT INTO r1 VALUES(1, 0x7FFFFFFF*-1, 0x7FFFFFFF);
99 INSERT INTO r1 VALUES(2, 0x7FFFFFFF*-1, 5);
100 INSERT INTO r1 VALUES(3, -5, 5);
101 INSERT INTO r1 VALUES(4, 5, 0x11111111);
102 INSERT INTO r1 VALUES(5, 5, 0x00800000);
103 INSERT INTO r1 VALUES(6, 5, 0x00008000);
104 INSERT INTO r1 VALUES(7, 5, 0x00000080);
105 INSERT INTO r1 VALUES(8, 5, 0x40490fdb);
106 INSERT INTO r1 VALUES(9, 0x7f800000, 0x7f900000);
107 SELECT rtreecheck('r1')