Can someone explain the above error which I get when I use 'indexed by' along with any valid index. Error seems to depend on the column list but it isn't mentioned on the indexed by documentation. sqlite> create table t(a,b); sqlite> create index ndx on t(b); sqlite> select a from t indexed by ndx; Error: no query solution sqlite> select b from t indexed by ndx; sqlite> select * from t indexed by ndx; Error: no query solution sqlite> I'm using 3.31.0