Proper fix is now on trunk and will appear in the next release. On 1/26/18, Jens Alfke <[email protected]> wrote: > > >> On Jan 26, 2018, at 1:36 PM, Richard Hipp <[email protected]> wrote: >> >> For now, please use CROSS JOIN instead of INNER JOIN to force the >> correct join order. > > You're right, that fixed the query. Thanks! > > I must admit, I don't understand the significance of join order here. It > seems to me that the results would be the same whether "itemDS" or > "categoryDS" is the outer loop; it's only performance that might change. > Could someone explain? > > —Jens > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
-- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
