On Fri, Sep 23, 2016 at 11:58 AM, Hick Gunter <h...@scigames.at> wrote:
> SQLite evaluates the WHERE clause from left to right, which means it needs > to evaluate xyz and thereby call json_extract first, even before it can > determine that no rows match the second condition. > > Maybe the transformation algorithm can be changed to check the "subselect > constraints" first? > Would be very clever indeed, to leverage the short-circuit semantic in that case. Great idea! --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
