Showing all 12 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
304022007-08-14
8:35
2014-03-10
14:31
MySQL Server: DMLVerified
(3651 days)
S25.0.37 CommunityLinux (RedHat 9.0)AnySELECT count(distinct) from mytable return 0
383972008-07-27
20:13
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5242 days)
S35.1.26, 5.0.62AnyAnyselect distinct + order by desc is executed inefficiently
462772009-07-17
21:33
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0, 5.1, 5.4, 6.0AnyAnydiffering results for equivalent queries using VAR_POP() & AVG() with DISTINCT
600232011-02-08
21:45
2014-05-22
12:13
MySQL Server: OptimizerVerifiedS55.5.8 , 5.1.51AnyAnyNo Loose Index Scan for GROUP BY / DISTINCT on InnoDB partitioned table
657922012-07-03
2:19
2012-07-04
9:54
MySQL Server: OptimizerVerified
(3806 days)
S55.1,5.5AnyAnyan unecessary Using temporary in distinct query
794972015-12-02
16:41
2015-12-02
17:51
MySQL Server: FULLTEXT searchVerified
(2559 days)
S25.7, 5.6.29, 5.7.11, 5.7.9Ubuntu (14.04)AnyFulltext index on a given column causes empty set for 'distinct' query
823082016-07-21
14:54
2016-07-21
17:54
MySQL Server: MyISAM storage engineVerified
(2327 days)
S15.7AnyAnyuse of DISTINCT with BIT and LONGTEXT leads to erroneous results
878352017-09-22
8:19
2018-12-19
1:41
MySQL Server: DMLVerified
(1899 days)
S15.7.19Ubuntu (Ubuntu 16.04.2 LTS)Anythe combination of SELECT DISTINCT and ORDER BY give wrong result for some data
914182018-06-26
7:08
2018-09-07
13:32
MySQL Server: OptimizerVerified
(1622 days)
S35.7,8.0.11, 5.7.22AnyAnyderived_merge causing inccorect results with distinct subquery and uuid()
1089362022-10-31
12:58
2022-10-31
14:16
MySQL Server: OptimizerVerified
(34 days)
S28.0.30AnyAnyValue change caused by DISTINCT
1089462022-11-01
3:35
2022-11-01
7:47
MySQL Server: OptimizerVerified
(33 days)
S38.0.30AnyAny0 changed to 0.0 caused by DISTINCT and UNION ALL
1091552022-11-22
5:43
2022-11-22
6:36
MySQL Server: OptimizerVerified
(12 days)
S58.0.18, 8.0.31AnyAnyInvalid scan on left join tables of which columns not in distinct output fields
Showing all 12 (Edit, Save, CSV, Feed)