| Showing 1-30 of 77 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 21849 | 2006-08-26 10:07 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5126 days) | S5 | 5.0.32-BK, 4 and 5, 5.1.42-bzr | Linux (linux) | Any | select count distinct has rotten performance on at least versions 4&5 of mysql. |
| 22057 | 2006-09-06 16:29 | 2006-09-06 20:06 | MySQL Server | Duplicate (6435 days) | S1 | 5.0.24 | Windows (WIN XP) | Any | SELECT DISTINCT RETURNING ERRONEOUS NUMBER OF ROWS |
| 22997 | 2006-10-05 1:38 | 2006-10-05 6:46 | MySQL Server | Not a Bug (6406 days) | S3 | 5.0.18-nt | Windows (windows) | Any | subselects with distincts take long time to process |
| 21705 | 2006-08-17 22:50 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6434 days) | S2 | 4.1.21/4.1/5.0/5.1BK | Linux (Linux) | Any | COUNT(DISTINCT field) with GROUP BY forces incorrect behaviour of LIMIT |
| 23709 | 2006-10-27 8:45 | 2006-10-27 12:40 | MySQL Server | Duplicate (6384 days) | S2 | 4.1.21 | Linux (Linux, others ?) | Any | Unable to ORDER BY date with DISTINCT |
| 24856 | 2006-12-06 16:07 | 2007-05-08 0:40 | MySQL Server | Closed (6191 days) | S3 | 4.1.22 / 5.0.22, 5.1 BK | Linux (Linux) | Any | distinct with constant item and rollup => missing summary lines |
| 24407 | 2006-11-17 21:59 | 2012-05-18 20:19 | MySQL Server | Duplicate (6361 days) | S2 | 4.1.21 | FreeBSD (FreeBSD 4.11) | Any | SELECT DISTINCT with ORDER BY does not sort correct |
| 25548 | 2007-01-11 14:47 | 2020-05-03 20:45 | MySQL Server: Optimizer | Duplicate (6300 days) | S2 | 5.0.34-BK, 5.0.27, 5.1 | Linux (Linux, Mac OSX Intel) | Any | Behavior change in INSERT INTO SELECT DISTINCT @var between 5.0.18 and 5.0.27 |
| 25551 | 2007-01-11 16:30 | 2007-02-08 18:04 | MySQL Server: Optimizer | Closed (6280 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 |
| 25602 | 2007-01-12 23:30 | 2007-06-26 19:13 | MySQL Server: MyISAM storage engine | Closed (6142 days) | S1 | 5.0.32, 5.0.33, 5.0.37, 5.0.44-BK | Linux (Linux (FC 6)) | Any | Error with /*!HIGH_PRIORITY SQL_CACHE SQL_BIG_RESULT*/ combined with DISTINCT |
| 26209 | 2007-02-09 6:47 | 2007-02-26 20:54 | MySQL Server: Views | Closed (6262 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 |
| 26901 | 2007-03-07 6:32 | 2007-03-07 21:03 | MySQL Server | Closed (6253 days) | S3 | 5.0.27-community-nt | Windows (windows 2003) | Any | select distinct f1 as a, f1 as b from view returns 2 columns b if index on f1 |
| 28514 | 2007-05-18 10:32 | 2007-05-18 10:52 | MySQL Server: General | Can't repeat (6181 days) | S2 | 5.0.30,5.0.32 | Linux (Ver 8.41 Distrib 5.0.32, for pc-linux-gnu on i486) | Any | group_concat(distinct) on text cols has different results than without distinct |
| 28364 | 2007-05-10 23:36 | 2015-03-15 20:45 | MySQL Server: MyISAM storage engine | No Feedback (6157 days) | S1 | 5.0.33, 5.0.41 | Linux (Gentoo) | Any | Mysql server crashes during a query |
| 29911 | 2007-07-19 19:39 | 2007-07-27 5:13 | MySQL Server: General | Closed (6111 days) | S2 | 5.0.45/4.1/5.1 | Linux | Any | DISTINCT adds a result to what should be an empty result set |
| 30175 | 2007-08-01 9:39 | 2007-08-01 13:43 | MySQL Server | Can't repeat (6106 days) | S2 | 5.0.40 | Linux | Any | GROUP BY returns wrong records with subquery condition NOT EXISTS |
| 30245 | 2007-08-05 20:44 | 2007-09-14 15:17 | MySQL Server | Closed (6062 days) | S3 | 5.0/5.1 | Any | Any | BIT type gets cast to LONG when DISTINCT or GROUP BY is used |
| 30402 | 2007-08-14 8:35 | 2014-03-10 14:31 | MySQL Server: DML | Verified (4153 days) | S2 | 5.0.37 Community | Linux (RedHat 9.0) | Any | SELECT count(distinct) from mytable return 0 |
| 31279 | 2007-09-28 13:59 | 2008-06-12 13:07 | MySQL Server: Charsets | Not a Bug (5790 days) | S2 | 5.0.51a | Windows (XP SP3, Server 2003 WE & EE) | Any | SELECT DISTINCT CAST AS CHAR truncates results |
| 35298 | 2008-03-14 17:45 | 2008-05-14 2:26 | MySQL Server | Closed (5819 days) | S2 | 5.0.56/5.0/5.1/6.0BK | Linux | Any | GROUP_CONCAT with DISTINCT can crash the server |
| 32798 | 2007-11-27 23:09 | 2008-01-28 17:41 | MySQL Server | Closed (5926 days) | S2 | 5.0.45/5.1/4.1 | Windows (Vista) | Any | DISTINCT in GROUP_CONCAT clause fails when ordering by a column with null values |
| 34008 | 2008-01-23 14:22 | 2008-01-28 19:20 | MySQL Server | Closed (5926 days) | S3 | 5.0.41 | Windows | Any | Server crashes with simple query involving DISTINCT, DIV and VARCHAR |
| 34044 | 2008-01-24 21:22 | 2008-02-29 17:49 | MySQL Server: Documentation | Closed (5894 days) | S2 | 4.1.16, 4.1, 5.0, 5.1, 6.0 BK | Any (MS Windows SP2, Linux) | Any | UNION ALL query wrong result order |
| 38397 | 2008-07-27 20:13 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5744 days) | S3 | 5.1.26, 5.0.62 | Any | Any | select distinct + order by desc is executed inefficiently |
| 36632 | 2008-05-09 17:09 | 2008-07-23 17:50 | MySQL Server: Views | Closed (5749 days) | S2 | 5.1.24-rc (64-bit server) | Any (Mac OS X 10.5.2, Ubuntu 64bit) | Any | Select distinct from a simple view on an InnoDB table returns incorrect results |
| 42037 | 2009-01-12 1:08 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5541 days) | S1 | 5.0.75, 4.1, 5.0, 5.1, 6.0 bzr | Linux (CentOS 4.7) | Any | Queries containing a subquery with DISTINCT and ORDER BY could cause a server c |
| 44821 | 2009-05-12 13:10 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5413 days) | S1 | 5.1.33, 5.1, 6.0 bzr | Any (Linux, Sun Solaris 10) | Any | select distinct on partitioned table returns wrong results |
| 45648 | 2009-06-22 9:20 | 2009-06-22 9:45 | MySQL Server: General | Not a Bug (5415 days) | S2 | 5.0.83 | Linux | Any | SELECT DISTINCT ... ORDER BY DESC returns wrong order |
| 46018 | 2009-07-07 19:16 | 2011-02-16 23:44 | MySQL Server: General | Closed (5157 days) | S3 | 5.0,5.1 | Any | Any | group_concat(distinct ...) uses max_heap_table_size for memory allocations |
| 46277 | 2009-07-17 21:33 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0, 5.1, 5.4, 6.0 | Any | Any | differing results for equivalent queries using VAR_POP() & AVG() with DISTINCT |
| Showing 1-30 of 77 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
