On Monday 05 November 2012 18:02:28 h...@tbbs.net wrote: > >>>> 2012/11/04 22:23 +0000, Stefan Kuhn >>>> > > select * from table order by udf(column, 'input_value') desc; > For my understanding, this should give the same result always. > <<<<<<<< > But if for your data function "udf" returns the same for more arguments > there is not enough to fix the order. In that case I have found that other > accidental things affect the order, things that one would not suspect: > howmuch store is used and needed for the ordering, ... a further reason for > showing what the function returns. If the order varies, although the > function returns the same in all cases, well, .... True, but I am missing records from the top ten which should definitly be in, so this should not be the problem here. I am investigating things further... Stefan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
