On Wed, Apr 17, 2013 at 7:48 AM, Clemens Ladisch <clem...@ladisch.de> wrote:
> Richard Hipp wrote: > > On Tue, Apr 16, 2013 at 1:15 PM, Mohit Sindhwani <m...@onghu.com> wrote: > >> Hi, I was looking at the RTree documentation page with one of my > >> colleagues - <http://www.sqlite.org/rtree.html> > >> > >> We tried the example with the schema in 3.1, populated the data from 3.2 > >> and then queried it using the query of 3.3 - we got no results while the > >> documentation says that "the query would very quickly locate the id of 1 > >> even if the R*Tree contained millions of entries". > >> > >> Is the line "AND minY>=35.00 AND maxY<=35.44;" supposed to be "AND > >> minY>=33.00 AND maxY<=35.44;" (33 instead of 35.00)? > > > > I copy/pasted the code and it all seems to work for me. My copy/paste > > follows: > > > > [...] > > .print --- one > > SELECT * FROM demo_index WHERE id=1; > > SELECT id FROM demo_index > > WHERE minX>=-81.08 AND maxX<=-80.58 > > AND minY>=35.00 AND maxY<=35.44; > > These are two queries. The second one outputs nothing, although its > description implies it should. > I get: drh@tallis:~/sqlite/bld$ ./sqlite3 <r1.txt --- one 1|-80.77490234375|-80.7746963500977|33.3775978088379|35.3778038024902 --- two 1 2 --- three 1 2 > > > .print --- two > > [...] > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
