Load only the candidate rows the indexes allow for the where clause (see candidatesOf): an index only narrows which
rows are read. Every condition, indexed or not, stays in parsed.where and is still applied to the candidates
afterwards (runQuery), so an index can make a query faster but never changes its result (where-clauses decision 3;
it used to remove the conditions it answered, and the 3 bugs fixed in #69 came from that split).
An indexed condition on a joined entity's field (exercises._id = 1) narrows that entity's rows only when every
row must meet it (directly under the top-level and, see requiredConditions). It stays in the tree too: the where
clause is then evaluated per pair of a row and a joined row (see whereTree).
Filled with each entity whose candidate rows were loaded here: they must not be reloaded (an
empty list otherwise reads as "not loaded yet", see readEntity).
Load only the candidate rows the indexes allow for the where clause (see candidatesOf): an index only narrows which rows are read. Every condition, indexed or not, stays in parsed.where and is still applied to the candidates afterwards (runQuery), so an index can make a query faster but never changes its result (where-clauses decision 3; it used to remove the conditions it answered, and the 3 bugs fixed in #69 came from that split).
An indexed condition on a joined entity's field (
exercises._id = 1) narrows that entity's rows only when every row must meet it (directly under the top-leveland, see requiredConditions). It stays in the tree too: the where clause is then evaluated per pair of a row and a joined row (see whereTree).