| « Show Previous 30 Entries | Showing 31-60 of 123 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 33348 | 2007-12-19 1:15 | 2012-05-18 20:19 | MySQL Server: MyISAM storage engine | Duplicate (5939 days) | S2 | 5.0.37 & 5.0.45 & 5.1 | Linux (Ubontu Fiesty and Gutsy) | Any | select does not return all records when we have a covering index on a column . |
| 33555 | 2007-12-28 15:00 | 2008-10-10 13:09 | MySQL Server: Partitions | Closed (5700 days) | S2 | 5.1.26RC | Linux (CENTOS5.2) | Any | Group By Query does not correctly aggregate partitions |
| 35002 | 2008-03-03 14:17 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5920 days) | S2 | 5.1.23-rc/5.1BK/5.0/6.0 | Linux (2.6.22.9-61.fc6) | Any | Wrong results returned when using derived table and group by |
| 36189 | 2008-04-17 22:44 | 2008-07-09 20:24 | MySQL Server: General | Can't repeat (5793 days) | S3 | 5.0.51a | Linux (RHES 4 and RHES 5) | Any | Order by is not being evaluated when a group by exists on the primary key |
| 37905 | 2008-07-06 16:19 | 2008-07-07 18:02 | MySQL Server | Unsupported (5795 days) | S3 | 5.0.51a | MacOS (part of XAMPP 0.7.2) | Any | SELECT COUNT with GROUP BY bug (see #7128) |
| 39169 | 2008-09-01 22:17 | 2008-10-10 8:06 | MySQL Server: DML | No Feedback (5700 days) | S1 | 6.0.4alpha, 6.0.6alpha | Windows (Windows XP Home) | Any | Unexpected behaviour when using GROUP BY and/or WHERE clauses |
| 36460 | 2008-05-02 0:14 | 2008-05-02 15:03 | MySQL Server | Closed (5861 days) | S2 | 5.1 | Any | Any | Subqueries eliminating duplicates needed by group by |
| 39543 | 2008-09-19 16:56 | 2018-02-10 16:42 | MySQL Server: DML | Closed (2290 days) | S3 | 5.0.67/5.1/6.0 | Linux (debian 4.0) | Any | Group by with case and lpad inside concat truncates values |
| 39554 | 2008-09-20 9:08 | 2011-02-16 23:43 | MySQL Server: Partitions | Can't repeat (5295 days) | S3 | 5.1.28-rc-community-log | Windows (2003 Server) | Any | select statement with joins and group by seems to be an endless loop |
| 36772 | 2008-05-16 23:04 | 2011-02-16 23:43 | MySQL Server: Charsets | Closed (5641 days) | S2 | 5.0BK/5.1BK/6.0BK | Any (Ubuntu (5.0.38-Ubuntu_0ubuntu1.4-log) and WinXP (5.0.45-community-nt)) | Any | When using UTF8, CONVERT with GROUP BY returns truncated results |
| 40572 | 2008-11-07 4:02 | 2008-11-07 4:12 | MySQL Server: Optimizer | Not a Bug (5672 days) | S3 | 5.0.58 | Any (Tested on Fedora 6 / WindowsXP) | Any | Group By across many inner joins does not aggregate properly |
| 40195 | 2008-10-21 8:35 | 2008-10-21 17:46 | MySQL Server: InnoDB storage engine | Not a Bug (5689 days) | S5 | 5.1.28 | Linux (SLES10) | Any | Slowdown queries by the use of groupby in Innodb |
| 41886 | 2009-01-05 20:53 | 2009-01-06 11:54 | MySQL Server: General | Not a Bug (5612 days) | S3 | 4.1.22, 5.0.67 | Linux | Any | max() and min() functions truncate result to 14 places on double columns |
| 39905 | 2008-10-07 10:43 | 2008-10-07 11:31 | MySQL Server: InnoDB storage engine | Not a Bug (5703 days) | S3 | 5.0 | Any | Any | Incorrect result with HAVING and no GROUP BY |
| 42948 | 2009-02-17 23:02 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5556 days) | S5 | 5.0.67-0ubuntu6, 6.0.11 | Linux (Ubuntu 8.10) | Any | MySQL Optimizer does not properly use Indexes on Views with "Group By" |
| 42322 | 2009-01-24 15:46 | 2009-01-24 15:56 | MySQL Server | Not a Bug (5594 days) | S2 | 5.1.30 | Windows (SP3) | Any | 5.1.30-community allows mixing of group and no group columns without group by |
| 43092 | 2009-02-22 21:09 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5560 days) | S3 | 5.0.67-0ubuntu6 | Linux (Ubuntu 8.10) | Any | Group by still optimizing out extra nulls |
| 42810 | 2009-02-12 22:31 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Duplicate (5574 days) | S2 | 5.1.31 | Windows (NT) | Any | min() messes up |
| 44117 | 2009-04-06 19:22 | 2009-04-07 10:19 | MySQL Server: Parser | Not a Bug (5521 days) | S3 | 5.1.33 | Any | Any | ORDER BY does nor work for a GROUP BY alias |
| 45224 | 2009-05-31 22:34 | 2009-06-01 10:28 | MySQL Server: Optimizer | Not a Bug (5466 days) | S3 | 5.4 | Any | Any | SELECT col_1 WHERE column(s) IN (subquery) AND condition GROUP BY col_n fails |
| 45226 | 2009-05-31 22:42 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (5321 days) | S3 | 5.4 | Any | Any | extra rows returned for queries using IN,GROUP BY and HAVING clauses |
| 45228 | 2009-05-31 22:56 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (5321 days) | S3 | 5.4 | Any | Any | Queries with WHERE <col_1> AND <condition> GROUP BY <col_2> produce bad results |
| 45373 | 2009-06-08 13:14 | 2022-09-04 20:45 | MySQL Server: Optimizer | Verified (5448 days) | S3 | 5.1.35-community, 5.1.36-bzr | Any | Any | INDEX FOR GROUP BY is not used if there is a LIMIT clause in the query |
| 46019 | 2009-07-07 19:21 | 2011-02-16 23:44 | MySQL Server: Views | Closed (5264 days) | S3 | 5.1.35, 5.0, 5.1, 5.4 bzr | Linux (Fedora Core 11) | Any | ERROR 1356 When selecting from within another view that has Group By |
| 46567 | 2009-08-05 14:24 | 2011-02-16 23:44 | MySQL Server: Documentation | Closed (5399 days) | S3 | 5.0, 5.1, 5.4/6.0 | Any | Any | Aggregate function documentation needs clarification for non-GROUP BY behavior |
| 46328 | 2009-07-21 20:54 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4927 days) | S3 | 6.0 | Any | Any | Use of aggregate function without GROUP BY clause returns many rows (vs. one ) |
| 46742 | 2009-08-15 13:30 | 2011-06-09 20:49 | Connector / NET | Closed (4728 days) | S3 | 6.0.4, 6.3.6 | Windows (windows 7) | Any | use " group by" statement in ado.net enetiy framework |
| 46011 | 2009-07-07 14:05 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (4968 days) | S3 | 5.1-bugteam | Any | Any | Regression after applying fix for bug #45828 |
| 46743 | 2009-08-15 17:14 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4926 days) | S3 | 5.4/6.0 | Any | Any | Azalea processing correlated, aggregate SELECT subqueries incorrectly |
| 48370 | 2009-10-28 10:32 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5182 days) | S1 | 5.1.40 | Windows | Any | Absolutely wrong calculations with GROUP BY and decimal fields when using IF |
| « Show Previous 30 Entries | Showing 31-60 of 123 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
