Showing 1-30 of 122 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
24838 | 2006-12-05 20:59 | 2006-12-05 21:27 | MySQL Server | Not a Bug (6350 days) | S3 | 5.0.22-standard | Linux (linux) | Any | group by compares strings case-insensitively |
24352 | 2006-11-16 6:11 | 2007-11-20 9:12 | MySQL Server | Can't repeat (6000 days) | S2 | 4.1.22, 4.1.9-nt-max-log | Windows (Windows XP) | Any | "=" operator failed rather than "LIKE" operator in GROUP BY statement |
25718 | 2007-01-19 12:32 | 2007-01-19 13:57 | MySQL Server | Can't repeat (6305 days) | S3 | 4.1.22 and 5.0.27 | Any | group by with alias in expression (follow up bug #11694) | |
25373 | 2007-01-02 19:48 | 2007-03-15 15:32 | MySQL Server | Closed (6250 days) | S2 | 5.0.30, 5.1bk | Linux (linux) | Any | rollup grand total not have NULL for group by field basd on stored function |
25758 | 2007-01-22 18:01 | 2007-02-14 19:09 | MySQL Server | Can't repeat (6279 days) | S2 | 5.0.25+, 4.1.19+ | Any (all) | Any | quoted string in ORDER BY causes GROUP BY |
25551 | 2007-01-11 16:30 | 2007-02-08 18:04 | MySQL Server: Optimizer | Closed (6285 days) | S3 | 4.1.22, 5.0.27, 5.0.34-BK | Linux (Linux, freebsd) | Any | inconsistent behaviour in grouping NULL, depending on index type |
26087 | 2007-02-05 15:27 | 2007-02-05 18:23 | MySQL Server | Closed (6288 days) | S3 | 5.0 | Unix | Any | Empty Result Set Returned When COUNT(), GROUP BY, and WHERE Are Used Together |
26132 | 2007-02-07 4:28 | 2007-04-15 7:15 | MySQL Server: MyISAM storage engine | Not a Bug (6219 days) | S3 | 5.1.14-beta | Linux (linux) | Any | Query failed |
26209 | 2007-02-09 6:47 | 2007-02-26 20:54 | MySQL Server: Views | Closed (6267 days) | S2 | 5.0.36-BK, 5.0.27 | Linux (Linux, winXP) | Any | wrong result using COUNT(DISTINCT ?) querying a VIEW with GROUP BY and ORDER BY |
27386 | 2007-03-22 23:25 | 2007-07-09 8:59 | MySQL Server: General | Not a Bug (6134 days) | S1 | 5.1.17 Beta | Any (Unknown(ISP) and Mac OS X) | Any | Queries are Returning Results Which are not Ordered |
27530 | 2007-03-29 17:17 | 2007-04-24 17:19 | MySQL Server | Closed (6210 days) | S3 | 5.0.37-log | Any (pc-linux-gnu x86_64) | Any | Incorrect calculation CRC32 value in GROUP BY requests |
28015 | 2007-04-22 11:23 | 2007-05-22 16:26 | MySQL Server | No Feedback (6182 days) | S1 | 4.x & 5.x | MacOS (x86) | Any | Order By + Group by does not Sort - Mac OS x x86 |
28494 | 2007-05-17 8:48 | 2007-06-19 1:12 | MySQL Server: General | Closed (6154 days) | S3 | 5.0.41, 5.1 | Linux | Any | Assigning to variable in SELECT spoils result of GROUP BY |
28281 | 2007-05-07 14:13 | 2007-06-19 13:46 | MySQL Server: General | Not a Bug (6154 days) | S2 | 5.0.44-BK, 5.0.37 (Community) | Windows (XP) | Any | GROUP BY returning recs in wrong order |
29918 | 2007-07-19 22:24 | 2007-07-19 23:37 | MySQL Server: General | Not a Bug (6124 days) | S3 | 5.0.44 | Linux (Gentoo) | Any | Assigning a variable in some SELECT queries yields invalid resuls |
29630 | 2007-07-08 19:27 | 2007-07-09 13:07 | MySQL Server | Closed (6134 days) | S2 | 5.0.41-community-nt | Windows | Any | "group by" doesnt work with subselects |
30175 | 2007-08-01 9:39 | 2007-08-01 13:43 | MySQL Server | Can't repeat (6111 days) | S2 | 5.0.40 | Linux | Any | GROUP BY returns wrong records with subquery condition NOT EXISTS |
30219 | 2007-08-03 3:40 | 2007-08-25 16:19 | MySQL Server: MyISAM storage engine | Closed (6087 days) | S2 | 5.0 (all) | Any | Any | GROUP BY with DISTINCT broken with BIT type in MyISAM in many cases |
29729 | 2007-07-11 18:06 | 2007-07-23 0:44 | MySQL Server: General | Closed (6120 days) | S2 | 5.0.44, 5.0.45 | Linux | Any | datetime compared with date failing to add zero time on group by query |
30245 | 2007-08-05 20:44 | 2007-09-14 15:17 | MySQL Server | Closed (6067 days) | S3 | 5.0/5.1 | Any | Any | BIT type gets cast to LONG when DISTINCT or GROUP BY is used |
30326 | 2007-08-09 1:24 | 2007-08-09 7:49 | MySQL Server: InnoDB storage engine | Not a Bug (6103 days) | S1 | 5.0.46 | Windows (Vista) | Any | UNION returns incorrect results to 14 decimals |
29209 | 2007-06-19 12:54 | 2007-08-01 12:21 | MySQL Server: Optimizer | Not a Bug (6111 days) | S3 | 5.0.44/5.1BK | Any | Any | Loose index scan is not used if key parts are in different order in the GROUP BY |
30596 | 2007-08-23 14:07 | 2007-10-23 15:59 | MySQL Server: Optimizer | Closed (6028 days) | S2 | Any | Any | GROUP BY optimization gives wrong result order | |
29796 | 2007-07-13 20:39 | 2007-08-13 21:49 | MySQL Server | No Feedback (6099 days) | S3 | 5.0.41 | Windows (XP Professional 5.1.2600) | Any | Correlated subquery return zero rows when Group By included in the outer query |
30665 | 2007-08-28 8:03 | 2007-11-13 18:59 | MySQL Server: Optimizer | Closed (6007 days) | S3 | 5.1.17 | Any | Any | Inconsistent optimization of IGNORE INDEX FOR {ORDER BY|GROUP BY} |
31226 | 2007-09-27 9:21 | 2007-09-28 9:32 | MySQL Server | Duplicate (6053 days) | S1 | 5.0.42 and up, 5.1 | Other (FreeBSD, Linux) | Any | Group by function crashes mysql |
31281 | 2007-09-28 15:09 | 2007-10-28 15:24 | MySQL Server: DML | No Feedback (6023 days) | S1 | 5.0.41-community-nt-log | Windows | Any | Group by and subquery issue in 5.0.41-community-nt-log |
31798 | 2007-10-23 19:47 | 2007-10-23 20:49 | MySQL Server: Optimizer | Not a Bug (6028 days) | S3 | 5.0.45 | Linux (Debian) | Any | LEFT JOIN query with COUNT() and GROUP BY produces wrong result |
28691 | 2007-05-25 20:16 | 2007-08-23 16:42 | MySQL Server: Optimizer | Not a Bug (6089 days) | S3 | 5.1.18 | Any | Any | GROUP BY optimization ignores functional dependency on unique/primary key |
33085 | 2007-12-08 13:22 | 2012-05-18 20:19 | MySQL Server: Stored Routines | Duplicate (5973 days) | S2 | 5.1-BK | Any | Any | Stored functions crash server when used in select list and group by |
Showing 1-30 of 122 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |