> From: Matt Neimeyer <m...@neimeyer.org> > > Generic code to draw a SELECT element on the screen > sometimes it ends > up like such... > > SELECT DISTINCT name AS myvalue,name AS mydisp FROM names > WHERE > name!="" ORDER BY myvalue > > On 4.1.22 this returns > > A A > B B > C C > D D > > On 5.0.22 this returns > > D D > D D > D D > D D > > The odd thing is that if I remove the order by clause it > works fine... > It also works fine if I remove the second copy of the > column BUT this > is generic code so it might also be doing something like > "productid as > myvalue,productname as mydisp" where the values are > different. > > Ultimately I can sort the array I end up with but it seems > like this > should work. Especially since it did in 4.x. > > Am I crazy? Doing something wrong? > >
Doesn't look crazy to me, and it works in 5.0.32 http://www.privatepaste.com/50RvhihKKm Perhaps time to patch that server ... Send instant messages to your online friends http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
