Re: [sqlite] GROUP BY optimizer cost problem with index

> create table stuff(a,b,c,d); > insert into stuff values(1,2,3,4); > create temp view v1 as select random()%100, > random()%100, random()%1000, random()%1 > from stuff x, stuff y; > insert into stuff select * from v1; > insert into stuff select * from v1; > insert into

[sqlite] GROUP BY optimizer cost problem with index

There seems to be an issue with the sqlite cost heuristic with an INDEX present on GROUP BY with certain types of WHERE clauses. Given the database formed by running these statements: create table stuff(a,b,c,d); insert into stuff values(1,2,3,4); create temp view v1 as select