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: [email protected] on behalf of David Burström Sent: Mon 1/17/2011 6:47 AM To: [email protected] 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

