On 8/14/18, Kris Adler <[email protected]> wrote: > So my question is: if I bind a value to the $key1 host parameter that makes > the json_extract expression match one used in an index-on-expression, > should the query planner then make use of the index-on-expression after the > statement is recompiled?
I'm guessing it will not, since the subroutine in the query planner that checks to see if an expression in the WHERE clause matches an expression in the index does not know that $key is equal to '$.name'. For the time being, you should hard-code the field name. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
