This may be the patch that fixes your problem... http://www.sqlite.org/src/info/ece641eb89 Was released in 3.7.3 Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems
________________________________ From: sqlite-users-boun...@sqlite.org on behalf of David Burström Sent: Mon 1/17/2011 6:47 AM To: sqlite-users@sqlite.org Subject: EXTERNAL:[sqlite] JOIN bug in 3.7.2, not in 3.6.22 Hello all! I stumbled across this strange bug during Android development on 2.2.1 late last night. Please run the following snippet in SQLite 3.7.2 and 3.6.22 to compare the differences. The comments shows what alterations you can make to make the query return the expected result.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users