[Bug 479250] [NEW] ORDER BY DESC in InnoDB not working

[Mark Schouten]

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:
root at db1:~/marks# lsb_release -rd
Description:	Ubuntu 8.04.3 LTS
Release:	8.04

root at 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.