On 10 Jul 2013, at 6:30pm, compscilaw . <bluebaroncan...@gmail.com> wrote:
> I'm getting unexpected and differing results between WebSQL(SQLite) and > SQLite. The query produces the correct results in WebSQL. I cannot answer your question but I have some of my own. First, can you remove the tables scans and hosts from your sample code ? They don't seem to play any part in your SELECT. Second, I notice that you have defined > CREATE TABLE whitelist( > whitelist_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, and that your entries in whitelist do not have NULL values for whitelist_id. Yet your SELECT specifies > WHERE w.whitelist_id IS NULL What do you expect to happen here ? That column can't be null. Third, can you identify one of the rows in programs you didn't expect to see in the result of the SELECT, so we know what we're investigating ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users