Hello Jens Miltner, >However, I'd still like to know whether the new behavior of returning >the DISTINCT results in 'arbitrary' order is expected.
Unless ORDER BY is specified, the result of any SELECT is by definition undefined. This undefined sort order has changed between previous versions and might do so again in the future. Ralf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users