Bug #4463 | GROUP takes the first-found values | ||
---|---|---|---|
Submitted: | 8 Jul 2004 15:01 | Modified: | 4 May 2007 12:13 |
Reporter: | Mr. Venom | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S4 (Feature request) |
Version: | <4.1 | OS: | Any (doesn't matter) |
Assigned to: | CPU Architecture: | Any |
[8 Jul 2004 15:01]
Mr. Venom
[4 May 2007 12:13]
Hartmut Holzgraefe
http://dev.mysql.com/doc/refman/5.0/en/group-by-hidden-fields.html "Do *not* use this feature if the columns you omit from the GROUP BY part are not constant in the group. The server is free to return any value from the group, so the results are indeterminate unless all values are the same."