Hi All
I have a following table:
create table if not exists t_expr (pid integer not null,
payload text not null)
create index if not exists t_expr_idx1 on t_expr(pid,
json_extract(payload,'$.index.id'))
I have some following data like:
insert into t_expr values (1, '{'index':{'id':"xxx"},'val':xxx}')
.
.
.
I found out when trying to query the table using something like:
select payload from t_expr where (pid between ? and ?) and
json_extract(payload, '$.index.id')=?
the json_extract part didn't work.
Query plan indicated "search table t_expr using index pid>? and pid<?"
I want to know whether indexes on expressions works only with single column
indexes
Regards
gelin yan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
