Dear SQLite developers, SQLite does not use covering index on following situation CREATE TABLE t(x json); CREATE INDEX i1 on t( json_extract(x, "$.name"));
explain query plan select json_extract(x,"$.name") from t where json_extract(x,"$.name")=?; 0|0|0|SEARCH TABLE t USING INDEX i1 (<expr>=?) explain query plan select json_extract(x,"$.name") from t; 0|0|0|SCAN TABLE t Since “$.name” already extracted and stored in index i1, Should SQLite using covering index on i1 rather than recalculate json_extract(x,”$.name”) every time? Regards. Zhai _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
