Bug #1586 | group by not working with an aggregate function on date field | ||
---|---|---|---|
Submitted: | 17 Oct 2003 6:32 | Modified: | 19 Oct 2003 15:00 |
Reporter: | Muraleedhar Ramapai | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 3.23.49 | OS: | Linux (RH 7.3) |
Assigned to: | CPU Architecture: | Any |
[17 Oct 2003 6:32]
Muraleedhar Ramapai
[19 Oct 2003 15:00]
Alexander Keremidarski
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.mysql.com/documentation/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php There is nothing wrong with your result. When adding column in select part whcih are not used in GROUP BY they get undefined values. This is how GRIUP BY is expected to work.