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 could never even know what row was chosen to represent that group. You should /never/ rely on any value you get outside the GROUP BY expressions or an aggregate function.
You almost certainly should be using a subselect to join grouped data with a particular, /well-defined/ row of the dataset that you're interested in. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
