Okay, I guess the previous version of our application was relying on
undocumented/unspecified behavior from previous MySQL versions. Anyhow,
I've worked out a work around already, so it's no skin off my back.
Thanks.
--
mysql ignores view order when selecting with group by
https://bugs.launchpad
Agreed, not a bug.
More specifically, the row that is chosen to represent a class of rows
defined by GROUP BY is undefined. In most other SQL implementations, it
is even /illegal/ to SELECT columns that are neither aggregate functions
nor the columns listed in the GROUP BY expression, and so you
This is not a bug. It's expected behavior.
** Changed in: mysql-dfsg-5.0 (Ubuntu)
Status: New => Invalid
--
mysql ignores view order when selecting with group by
https://bugs.launchpad.net/bugs/247727
You received this bug notification because you are a member of Ubuntu
Bugs, which is sub
This is expected behavior.
http://dev.mysql.com/doc/refman/5.0/en/select.html
"If you use GROUP BY, output rows are sorted according to the GROUP BY
columns as if you had an ORDER BY for the same columns."
"If ORDER BY occurs within a subquery and also is applied in the outer
query, the outermost
** Bug watch added: MySQL Bug System #38061
http://bugs.mysql.com/bug.php?id=38061
** Also affects: mysql-server via
http://bugs.mysql.com/bug.php?id=38061
Importance: Unknown
Status: Unknown
--
mysql ignores view order when selecting with group by
https://bugs.launchpad.net/bugs
Oh, I'm using the MySQL version from Hardy Heron (8.04LTS), with latest
updates:
$ lsb_release -rd
Description:Ubuntu 8.04.1
Release:8.04
$ dpkg --status mysql-server
Package: mysql-common
...
Source: mysql-dfsg-5.0
Version: 5.0.51a-3ubuntu5.1
--
mysql ignores view order when selecti
