On Fri, Sep 23, 2016 at 11:58 AM, Hick Gunter <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
