Hello Michael,

Tuesday, September 30, 2008, 8:00:36 PM, you wrote:
Andrew>> However if the specific sorting algorithm is not stable it *might*
MW> It's not stable; MySQL is using several different technics to
MW> calculate GROUP BY and may thus return the rows in any order within
MW> the group by.

Thanks for clarification.

MW> In general with SQL:  Don't assume any order of rows if you don't
MW> explicitely specify a sort order.

Sure. But sometimes, knowing how the system works internally, we can
still make a kludge. 

-- 
Best regards,
 Andrew                            mailto:[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to