Andreas Wicker <[email protected]> wrote: > A simple query like this works fine with both versions, the result is sorted > NOCASE by the Album column:
Purely by accident of implementation. No particular order of rows in the resultset is guaranteed, unless there's an ORDER BY clause. If you rely on a particular order, specify it explicitly. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
