Hello, A query against the xbmc database doesn't return results anymore when sqlite-3.8.1 is used. With sqlite-3.8.0.2, the query returns results against the identical database just fine. Please note that I'm just an xbmc user, not a developer. It's been quite a while since I last posted to a mailing list, I hope the gmail web client doesn't violate netiquette.
You can find a dump of a minimal database to reproduce the problem here: https://gist.github.com/ferdinandhuebner/d0f3aad4b74e38940c3e The query that doesn't return any rows: https://gist.github.com/ferdinandhuebner/1bb14de6a58699afbebe You can find a bug report on xbmc's trac: http://trac.xbmc.org/ticket/14646 To summarize what we figured out so far: - The problem with the query seems to be the join on the "files" table - The join on the "files" table is redundant because it is already joined in the view "episodeview" - If you replace the join with a left outer join the query returns results and the aggregate on files.playCount is not zero - If you join with a cast to integer the query returns results even though the datatypes are already of type integer If you need any more information, don't hesitate to ask. Thank you for your help, Ferdinand _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
