Showing all 21 (Edit, Save, CSV, Feed) |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
113135 | 2023-11-20 3:03 | 2023-11-20 15:34 | MySQL Server: DML | Verified (388 days) | S3 | 8.0 | Any | Any | DISTINCT JOIN ORDER BY statements ignore ORDER BY when tmp_table_size is small |
87835 | 2017-09-22 8:19 | 2018-12-19 1:41 | MySQL Server: DML | Verified (2638 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 |
30402 | 2007-08-14 8:35 | 2014-03-10 14:31 | MySQL Server: DML | Verified (4390 days) | S2 | 5.0.37 Community | Linux (RedHat 9.0) | Any | SELECT count(distinct) from mytable return 0 |
79497 | 2015-12-02 16:41 | 2015-12-02 17:51 | MySQL Server: FULLTEXT search | Verified (3298 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 | 2023-07-31 15:25 | MySQL Server: MyISAM storage engine | Verified (3066 days) | S1 | 5.7 | Any | Any | use of DISTINCT with BIT and LONGTEXT leads to erroneous results |
108946 | 2022-11-01 3:35 | 2022-12-13 4:12 | MySQL Server: Optimizer | Verified (730 days) | S3 | 8.0.30 | Any | Any | 0 changed to 0.0 caused by DISTINCT and UNION ALL |
109155 | 2022-11-22 5:43 | 2023-12-13 11:44 | MySQL Server: Optimizer | Verified (751 days) | S5 | 8.0.18, 8.0.31, 8.0.35 | Any | Any | Invalid scan on left join tables of which columns not in distinct output fields |
109363 | 2022-12-13 13:08 | 2022-12-16 14:50 | MySQL Server: Optimizer | Verified (727 days) | S3 | 8.0.4, 8.0.31 | Any | Any | 0 changed to -0 caused by DISTINCT and UNION ALL |
109367 | 2022-12-13 16:11 | 2022-12-14 5:58 | MySQL Server: Optimizer | Verified (729 days) | S3 | 5.7.22, 8.0.31 | Any | Any | value changed caused by DISTINCT and JOIN |
109362 | 2022-12-13 12:55 | 2022-12-13 13:20 | MySQL Server: Optimizer | Verified (730 days) | S2 | 8.0.13, 8.0.31 | Any | Any | Extra line caused by DISTINCT and key |
109356 | 2022-12-13 7:01 | 2022-12-13 7:56 | MySQL Server: Optimizer | Verified (730 days) | S2 | 8.0.16, 8.0.31 | Any | Any | Extra line caused by DISTINCT and IS TRUE |
109354 | 2022-12-13 5:43 | 2022-12-13 7:15 | MySQL Server: Optimizer | Verified (730 days) | S3 | 8.0.21, 8.0.30, 8.0.31 | Any | Any | Numeric format change caused by DISTINCT, UNION and NULL |
109353 | 2022-12-13 5:24 | 2022-12-13 7:12 | MySQL Server: Optimizer | Verified (730 days) | S2 | 8.0.22, 8.0.31 | Any | Any | Extra line caused by DISTINCT and a certain number of '0' |
109352 | 2022-12-13 5:00 | 2022-12-13 6:43 | MySQL Server: Optimizer | Verified (730 days) | S3 | 8.0.23, 8.0.31 | Any | Any | Numeric format change caused by DISTINCT and UCASE |
109351 | 2022-12-13 4:46 | 2022-12-13 6:35 | MySQL Server: Optimizer | Verified (730 days) | S2 | 8.0.28, 8.0.31 | Any | Any | Value change caused by DISTINCT and date functions |
108936 | 2022-10-31 12:58 | 2022-12-13 3:56 | MySQL Server: Optimizer | Verified (730 days) | S2 | 8.0.30 | Any | Any | Value change caused by DISTINCT |
91418 | 2018-06-26 7:08 | 2018-09-07 13:32 | MySQL Server: Optimizer | Verified (2361 days) | S3 | 5.7,8.0.11, 5.7.22 | Any | Any | derived_merge causing inccorect results with distinct subquery and uuid() |
65792 | 2012-07-03 2:19 | 2012-07-04 9:54 | MySQL Server: Optimizer | Verified (4545 days) | S5 | 5.1,5.5 | Any | Any | an unecessary Using temporary in distinct query |
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 |
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 |
38397 | 2008-07-27 20:13 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5981 days) | S3 | 5.1.26, 5.0.62 | Any | Any | select distinct + order by desc is executed inefficiently |
Showing all 21 (Edit, Save, CSV, Feed) |