Bug? Distinct AS with Order By

2009-10-22 Thread Matt Neimeyer
I'm not sure what to search on to see if someone has reported this as a bug or if I'm doing something wrong... 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

Re: Bug? Distinct AS with Order By

2009-10-22 Thread Glyn Astill
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

Re: Bug? Distinct AS with Order By

2009-10-22 Thread Glyn Astill
From: Glyn Astill glynast...@yahoo.co.uk Doesn't look crazy to me, and it works in 5.0.32 http://www.privatepaste.com/50RvhihKKm Perhaps time to patch that server ... I've guessed at the table def there, obviously your def may be different and that would surely affect the palanners