Hi, I recently noticed something similar to the following behaviour:
sqlite> .version SQLite 3.8.4.3 2014-04-03 16:53:12 a611fa96c4a848614efe899130359c9f6fb889c3 sqlite> CREATE TABLE t1 (x, y); sqlite> INSERT INTO t1 VALUES (1, 1), (2, 0); sqlite> SELECT x, y FROM t1 GROUP BY x, y ORDER BY x,y; 1|1 2|0 sqlite> CREATE INDEX i1 ON t1 (y, x); -- (sic) sqlite> SELECT x, y FROM t1 GROUP BY x, y ORDER BY x, y; 2|0 1|1 The second result appears to be ignoring the ORDER BY clause. Is this a bug, or am I missing something obvious? Best regards, foxlit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users