On 1/26/18, Jens Alfke <[email protected]> wrote: > > # This is the query that occurs in a bug report I got from a developer; it > should return two rows but instead returns none: > SELECT "itemDS".id, "categoryDS".id > FROM docs AS "categoryDS" > INNER JOIN docs AS "itemDS" > ON (EXISTS (SELECT 1 FROM json_each("categoryDS".body, '$.items') AS > _item > WHERE _item.value = "itemDS".id));
For now, please use CROSS JOIN instead of INNER JOIN to force the correct join order. I'll investigate further to see if this is something SQLite ought to be doing automatically. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
