Public bug reported: When selecting data from a table and ordering on the primary key, Mysql will not do anything with the given 'ORDER BY'. Please see Mysql bugs: http://bugs.mysql.com/bug.php?id=31001 http://bugs.mysql.com/bug.php?id=28591
(And maybe the fix? http://lists.mysql.com/commits/30965) This is already fixed in 9.04, but not in Hardy. Since this is quite an annoying bug imho, this should be fixed and pushed through -updates. Especially since Hardy is LTS and will be used for some time. :) Extra info: r...@db1:~/marks# lsb_release -rd Description: Ubuntu 8.04.3 LTS Release: 8.04 r...@db1:~/marks# apt-cache policy mysql-server-5.0 mysql-server-5.0: Installed: 5.0.51a-3ubuntu5.4 Candidate: 5.0.51a-3ubuntu5.4 Version table: *** 5.0.51a-3ubuntu5.4 0 500 http://ubuntu.local hardy-updates/main Packages 500 http://ubuntu.local hardy-security/main Packages 100 /var/lib/dpkg/status 5.0.51a-3ubuntu5 0 500 http://ubuntu.local hardy/main Packages ** Affects: mysql-dfsg-5.0 (Ubuntu) Importance: Undecided Status: New -- ORDER BY DESC in InnoDB not working https://bugs.launchpad.net/bugs/479250 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
