Bug #2927 | EXTRACT() with GROUP BY produces wrong results | ||
---|---|---|---|
Submitted: | 23 Feb 2004 10:49 | Modified: | 10 Aug 2005 17:28 |
Reporter: | Dean Ellis | Email Updates: | |
Status: | Won't fix | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 3.23.58 | OS: | Linux (Linux) |
Assigned to: | Ramil Kalimullin | CPU Architecture: | Any |
[23 Feb 2004 10:49]
Dean Ellis
[20 Feb 2005 1:35]
Martin Friebe
The result looks valid to me, after applying the where, we look at the remaining rows: 2 in 2003-01 with v = 1 and v = 2 ( sum 3 / month 1) 1 in 2003-04 with v = 1 ( sum 1 / month 4) and the row in 2002-04 is not in the result
[20 Feb 2005 1:41]
Martin Friebe
sorry, been on the wrong version, please ignore previous
[10 Aug 2005 17:28]
Jim Winstead
This bug isn't critical enough to warrant a fix in 3.23, and as noted it already works in 4.0 and later.