I understood what's the matter. The query was incorrect. I tested this on posgresql.
SQLSTATE[42803]: Grouping error: 7 ERROR: column "t.v3" must appear in the GROUP BY clause or be used in an aggregate function It seems to me that sqlite should issue a similar message. Correct query is SELECT v1,v2,sum(sum(v3+v4)) OVER (PARTITION BY v2 ORDER BY v1) as val FROM t GROUP BY v1,v2; v1 v2 val 1 1 10001 2 1 10011 3 1 11111 -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
