2010/10/26 Dan Kennedy <danielk1...@gmail.com> > The sorting happens after the grouping. And it is while processing > the GROUP BY clause that SQLite is forced to select an arbitrary > record from the user_record table. > > See here: > > http://www.sqlite.org/lang_select.html#resultset > > Third paragraph under the third bullet point.
No. See paragraph under bullet points: "The list of expressions between the SELECT and FROM keywords". Sort condition IS NOT the expression from the third bullet point. For sorting we may to see the part "ORDER BY and LIMIT/OFFSET Clauses". In the original test script the problem was when two rows are equal for sorting condition. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users