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

Reply via email to