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)
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.

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  Edit
Everyone can see this information.

Other bug subscribers