On Sun, Mar 3, 2013 at 2:48 PM, Tom Matrix <ratomat...@gmail.com> wrote:
> > I’ve encountered a problem, which is hardly reproducable on arbitrary > databases, therefore I attached one. > A simple, reproducible test case for (what we think is) your problem can be seen in this ticket: www.sqlite.org/src/tktview/fc7bd6358f59b This bug has been latent in SQLite for almost four years and you are the first to hit it. Probably this is because not many applications contain A=B in the WHERE clause where A is a text expression and B is an integer expression. You can probably work around the problem by changing your schema so that entries.measurementid is an integer rather than text. This does not excuse SQLite: It is still getting the wrong answer and needs to be fixed. We are working on a fix now. But a simple change to your schema will work around the problem and get you going even before that fix is available. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users