| Showing all 20 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 30402 | 2007-08-14 8:35 | 2014-03-10 14:31 | MySQL Server: DML | Verified (3768 days) | S2 | 5.0.37 Community | Linux (RedHat 9.0) | Any | SELECT count(distinct) from mytable return 0 |
| 38397 | 2008-07-27 20:13 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5359 days) | S3 | 5.1.26, 5.0.62 | Any | Any | select distinct + order by desc is executed inefficiently |
| 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 |
| 60023 | 2011-02-08 21:45 | 2014-05-22 12:13 | MySQL Server: Optimizer | Verified | S5 | 5.5.8 , 5.1.51 | Any | Any | No Loose Index Scan for GROUP BY / DISTINCT on InnoDB partitioned table |
| 65792 | 2012-07-03 2:19 | 2012-07-04 9:54 | MySQL Server: Optimizer | Verified (3923 days) | S5 | 5.1,5.5 | Any | Any | an unecessary Using temporary in distinct query |
| 79497 | 2015-12-02 16:41 | 2015-12-02 17:51 | MySQL Server: FULLTEXT search | Verified (2676 days) | S2 | 5.7, 5.6.29, 5.7.11, 5.7.9 | Ubuntu (14.04) | Any | Fulltext index on a given column causes empty set for 'distinct' query |
| 82308 | 2016-07-21 14:54 | 2016-07-21 17:54 | MySQL Server: MyISAM storage engine | Verified (2444 days) | S1 | 5.7 | Any | Any | use of DISTINCT with BIT and LONGTEXT leads to erroneous results |
| 87835 | 2017-09-22 8:19 | 2018-12-19 1:41 | MySQL Server: DML | Verified (2016 days) | S1 | 5.7.19 | Ubuntu (Ubuntu 16.04.2 LTS) | Any | the combination of SELECT DISTINCT and ORDER BY give wrong result for some data |
| 91418 | 2018-06-26 7:08 | 2018-09-07 13:32 | MySQL Server: Optimizer | Verified (1739 days) | S3 | 5.7,8.0.11, 5.7.22 | Any | Any | derived_merge causing inccorect results with distinct subquery and uuid() |
| 109155 | 2022-11-22 5:43 | 2022-11-22 6:36 | MySQL Server: Optimizer | Verified (129 days) | S5 | 8.0.18, 8.0.31 | Any | Any | Invalid scan on left join tables of which columns not in distinct output fields |
| 108936 | 2022-10-31 12:58 | 2022-12-13 3:56 | MySQL Server: Optimizer | Verified (108 days) | S2 | 8.0.30 | Any | Any | Value change caused by DISTINCT |
| 108946 | 2022-11-01 3:35 | 2022-12-13 4:12 | MySQL Server: Optimizer | Verified (108 days) | S3 | 8.0.30 | Any | Any | 0 changed to 0.0 caused by DISTINCT and UNION ALL |
| 109351 | 2022-12-13 4:46 | 2022-12-13 6:35 | MySQL Server: Optimizer | Verified (108 days) | S2 | 8.0.28, 8.0.31 | Any | Any | Value change caused by DISTINCT and date functions |
| 109352 | 2022-12-13 5:00 | 2022-12-13 6:43 | MySQL Server: Optimizer | Verified (108 days) | S3 | 8.0.23, 8.0.31 | Any | Any | Numeric format change caused by DISTINCT and UCASE |
| 109353 | 2022-12-13 5:24 | 2022-12-13 7:12 | MySQL Server: Optimizer | Verified (108 days) | S2 | 8.0.22, 8.0.31 | Any | Any | Extra line caused by DISTINCT and a certain number of '0' |
| 109354 | 2022-12-13 5:43 | 2022-12-13 7:15 | MySQL Server: Optimizer | Verified (108 days) | S3 | 8.0.21, 8.0.30, 8.0.31 | Any | Any | Numeric format change caused by DISTINCT, UNION and NULL |
| 109356 | 2022-12-13 7:01 | 2022-12-13 7:56 | MySQL Server: Optimizer | Verified (108 days) | S2 | 8.0.16, 8.0.31 | Any | Any | Extra line caused by DISTINCT and IS TRUE |
| 109362 | 2022-12-13 12:55 | 2022-12-13 13:20 | MySQL Server: Optimizer | Verified (108 days) | S2 | 8.0.13, 8.0.31 | Any | Any | Extra line caused by DISTINCT and key |
| 109367 | 2022-12-13 16:11 | 2022-12-14 5:58 | MySQL Server: Optimizer | Verified (107 days) | S3 | 5.7.22, 8.0.31 | Any | Any | value changed caused by DISTINCT and JOIN |
| 109363 | 2022-12-13 13:08 | 2022-12-16 14:50 | MySQL Server: Optimizer | Verified (105 days) | S3 | 8.0.4, 8.0.31 | Any | Any | 0 changed to -0 caused by DISTINCT and UNION ALL |
| Showing all 20 (Edit, Save, CSV, Feed) |
