On 11/17/16, Richard Hipp <d...@sqlite.org> wrote: > On 11/17/16, Paul <de...@ukr.net> wrote: >> That's why there was a LEFT JOIN in the first place, but as it seems, it >> wasn't that good idea. > > Try using CROSS JOIN instead of just JOIN or LEFT JOIN. The query > planner in SQLite will not reorder a CROSS JOIN.
But, as it turns out, if you use CROSS JOIN it goes back to sorting. Bummer. Ok, a new optimization opportunity. It gets the correct answer, though, so this is not considered a bug. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
