Probably related: Compound join with a left outer join generates different execution plans:
LEFT JOIN ( b JOIN c ON <cond> ) WHERE b.something = 5 vs. LEFT JOIN ( b JOIN c ON <cond> AND b.something = 5 ) WHERE b.something IS NOT NULL -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
