Ubuntu
mysql-dfsg-5.0 package

ORDER BY DESC in InnoDB not working

Bug #479250 reported by Mark Schouten
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
mysql-dfsg-5.0 (Ubuntu)
Fix Released
Undecided
Unassigned
Hardy
Won't Fix
Medium
Unassigned
Karmic
Fix Released
Undecided
Unassigned

Bug Description

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

root@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

Revision history for this message
Chuck Short (zulcss) wrote :

Im going to mark this fixed for karmic but it should be ok for an SRU.

Changed in mysql-dfsg-5.0 (Ubuntu Karmic):
status: New → Fix Released
Changed in mysql-dfsg-5.0 (Ubuntu Hardy):
status: New → Confirmed
importance: Undecided → Wishlist
Revision history for this message
Mark Schouten (mark-prevented) wrote :

Does this mean we have to wait until the next security-bug found in Mysql to get this bug fixed?

Revision history for this message
Chuck Short (zulcss) wrote :

No it should appear soon once I have tested the backporting the patch.

Regards
chuck

Changed in mysql-dfsg-5.0 (Ubuntu):
status: New → Fix Released
Chuck Short (zulcss)
Changed in mysql-dfsg-5.0 (Ubuntu Hardy):
importance: Wishlist → Medium
Revision history for this message
Sander Smeenk (ubuntu-freshdot) wrote :

This bug is hitting me too and it's quite annoying. Any chance on getting the fix out soon?
Rows are now returned unaffected by any sorting order, in the order i've inserted them.

Revision history for this message
Rolf Leggewie (r0lf) wrote :

Hardy has seen the end of its life and is no longer receiving any updates. Marking the Hardy task for this ticket as "Won't Fix".

Changed in mysql-dfsg-5.0 (Ubuntu Hardy):
status: Confirmed → Won't Fix
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.