[debian-mysql] Bug#470854: mysql-server: wrong results with GROUP BY ... ORDER BY

Joao Paulo Magalhaes joaoppmagalhaes at gmail.com
Fri Mar 14 01:19:38 UTC 2008


Package: mysql-server
Version: 5.0.51-3
Severity: grave
Justification: renders package unusable

When mixing GROUP BY ... ORDER BY clauses in a query, the results are not
sorted by any of the ORDER BY columns. 

This is a problem known with 5.0.51 - a bug with more details has been filed already in
MySQL: http://bugs.mysql.com/bug.php?id=35181.

Apparently this will be fixed in 5.1.23.

-- System Information:
Debian Release: lenny/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)

Kernel: Linux 2.6.23.9kornel (SMP w/2 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server depends on:
ii  mysql-server-5.0              5.0.51-3   MySQL database server binaries

mysql-server recommends no packages.

-- no debconf information





More information about the pkg-mysql-maint mailing list