On Wed, Nov 5, 2014 at 8:12 AM, Clemens Ladisch <clem...@ladisch.de> wrote:
> > The WHERE expression then makes the outer join meaningless, > Thank you, Clemens - I missed that detail. So the suggestion is that we should enhance the SQLite query planner to detect when the WHERE clause requires some column in the right-hand table of a LEFT JOIN to be non-NULL and then promote that join to a normal INNER JOIN. That seems like a reasonable enhancement request which we will take under advisement. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
