Re: does DISTINCT kill ORDER BY?

Just for the archives: looks like I bumped into bug #21456: http://bugs.mysql.com/bug.php?id=21456 This bug has been fixed in 4.1.22 and 5.0.25, so I'll just have to upgrade. Thanks anyway Markus Markus Hoenicka <[EMAIL PROTECTED]> was heard to say: > Chris <[EMAIL PROTECT

Re: does DISTINCT kill ORDER BY?

modified clause further restricts the results selected by refdb_id with the same effect regarding the sorting. BTW the above results were obtained with mysql.exe Ver 14.7 Distrib 4.1.10, for Win95/Win98 (i32) so the problem is neither specific to the FreeBSD port nor to a particular 4.1.x versio

does DISTINCT kill ORDER BY?

dex to sort the result, DISTINCT queries won't be sorted at all. These results were obtained with: mysql Ver 14.7 Distrib 4.1.21, for portbld-freebsd6.1 (i386) using 5.0 FreeBSD yeti.mininet 6.1-RELEASE FreeBSD 6.1-RELEASE #1: Mon Aug 28 22:24:48 CEST 2006 [EMAIL PROTECTED]:/usr/src/s

how to contribute new prebuilt clients for Cygwin

sound like a good idea to them. NB I'm not subscribed to the list, please CC me. Thanks! regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] http://ourworld.compuserve.com/homepages/hoenicka_markus/ - Before posting, pl