I've run into an R-tree query regression in the latest beta of Mac OS X 10.10. Looks like Apple upgraded the built-in SQLite library to version 3.8.5. (I'm not sure what version was in the previous beta, but the current released Mac OS X, 10.9.4, has version 3.7.13.)
I looked at the list of recent sqlite bugs and found "Problem with rtree tables with IN() operators or as the inner loop of a join"[1], which looks a lot like what I'm seeing — basically an r-tree bbox query that traverses a foreign key into another table isn't returning any rows. According to the report, the regression was introduced in SQLite 3.8.5, and was only fixed a month ago (Jul 29 2014) so it's not in any release yet. :-( I've got a test case in the form of a SQL file [2] that demonstrates my problem. I'm not 100% sure this is the same as the reported ticket, though. I'd appreciate it if someone could take a look and confirm whether I've run into the same problem. And if it is the same problem, then the question becomes when the fix will appear in a release. Hopefully in time for Apple to upgrade their SQLite library, otherwise R-tree queries are going to be broken in 10.10. Thanks, —Jens [1]: http://www.sqlite.org/src/tktview?name=d2889096e7 <http://www.sqlite.org/src/tktview?name=d2889096e7> [2]: https://gist.github.com/snej/f76733c4a65902ab7b32 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
