Showing all 11 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version Target OS CPU Summary Assigned
304022007-08-14
8:35
2014-03-10
14:31
MySQL Server: DMLVerified
(2051 days)
S25.0.37 CommunityLinux (RedHat 9.0)AnySELECT count(distinct) from mytable return 0  
383972008-07-27
20:13
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3642 days)
S35.1.26, 5.0.62AnyAnyselect distinct + order by desc is executed inefficiently  
462772009-07-17
21:33
2011-02-16
23:44
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
(2206 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
(959 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
(727 days)
S15.7AnyAnyuse of DISTINCT with BIT and LONGTEXT leads to erroneous results  
844452017-01-09
9:29
2017-08-01
3:20
MySQL Server: DMLVerified
(552 days)
S15.7.16, 5.7.17LinuxAnyselect distinct with constant value for left join mysql 5.7.16  
878352017-09-22
8:19
2017-09-22
10:33
MySQL Server: DMLVerified
(299 days)
S15.7.19Ubuntu (Ubuntu 16.04.2 LTS)Anythe combination of SELECT DISTINCT and ORDER BY give wrong result for some data  
909922018-05-23
14:01
2018-05-23
15:09
MySQL Server: DMLVerified
(56 days)
S28.0.11AnyAnyDISTINCT ignores window functions  
914182018-06-26
7:08
2018-06-26
7:37
MySQL Server: OptimizerVerified
(22 days)
S35.7,8.0.11, 5.7.22AnyAnyderived_merge causing inccorect results with distinct subquery and uuid()  
Showing all 11 (Edit, Save, CSV, Feed)