More strange things: SELECT x, sequence() AS y FROM t1 WHERE y>0 AND y<99 order by x desc;
9, 2 8, 3 7, 4 SELECT x, 0+sequence() AS y FROM t1 WHERE y>0 AND y<99 order by x desc; 9, 6 8, 6 7, 6 Seems that this optimization a little bit broken... -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users