MySQL 5.0.51: ORDER BY not working with GROUP BY

Bug #202706 reported by Rob van der Linde
4
Affects Status Importance Assigned to Milestone
mysql-dfsg-5.0 (Ubuntu)
Fix Released
High
Jamie Strandboge

Bug Description

Binary package hint: mysql-server-5.0

I have an existing website running on Wordpress, I moved it from an Edgy to a new Hardy server and post were shown in reverse order.

I have posted about the issue on the Wordrpess forums, and other people are having this issue too. The wordpress forum moderators say MySQL 5.0.51 is broken, here is the sticky post:

http://wordpress.org/support/topic/154622?replies=15

This looks like a serious issue, and I hope we can still push a new version of MySQL before Hardy gets released, it will be a real shame to see Hardy getting shipped with a broken version of MySQL.

Tags: regression
Revision history for this message
Rob van der Linde (robvdl) wrote :

Here's the actual MySQL bug for tis problem:

http://bugs.mysql.com/bug.php?id=32202

Daniel Hahler (blueyed)
Changed in mysql-dfsg-5.0:
importance: Undecided → High
status: New → Triaged
Revision history for this message
Chuck Short (zulcss) wrote :

Im taking a look at this now.

Changed in mysql-dfsg-5.0:
status: Triaged → In Progress
Changed in mysql-dfsg-5.0:
assignee: nobody → jamie-strandboge
status: In Progress → Triaged
Revision history for this message
Jamie Strandboge (jdstrand) wrote :

Verified hardy is affected. Preparing patch.

Changed in mysql-dfsg-5.0:
status: Triaged → In Progress
Changed in mysql-dfsg-5.0:
status: In Progress → Fix Committed
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package mysql-dfsg-5.0 - 5.0.51a-3ubuntu2

---------------
mysql-dfsg-5.0 (5.0.51a-3ubuntu2) hardy; urgency=low

  * debian/patches/92_fix_order_by32202.dpatch: fix for ORDER BY not working
    with GROUP BY (LP: #202706)
  * References:
    http://bugs.mysql.com/bug.php?id=32202

 -- Jamie Strandboge <email address hidden> Mon, 17 Mar 2008 07:35:15 -0400

Changed in mysql-dfsg-5.0:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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