Showing all 10 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version Target OS Summary Assigned
304022007-08-14
8:35
2014-03-10
14:31
MySQL Server: DMLVerified
(1836 days)
S25.0.37 CommunityLinux (RedHat 9.0)SELECT count(distinct) from mytable return 0  
383972008-07-27
20:13
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3427 days)
S35.1.26, 5.0.62Anyselect distinct + order by desc is executed inefficiently  
387202008-08-11
14:07
2012-05-18
20:19
MySQL Server: CharsetsVerified
(3412 days)
S25.0, 5.1, 6.0 bzrLinux (Etch 4.0(am64 and x86))SELECT DISTINCT on multiple attributes containing spaces in UTF8 are slow. Assigned Account
462772009-07-17
21:33
2011-02-16
23:44
MySQL Server: OptimizerVerifiedS35.0, 5.1, 5.4, 6.0Anydiffering 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.51AnyNo Loose Index Scan for GROUP BY / DISTINCT on InnoDB partitioned table  
657922012-07-03
2:19
2012-07-04
9:54
MySQL Server: OptimizerVerified
(1991 days)
S55.1,5.5Anyan unecessary Using temporary in distinct query  
794972015-12-02
16:41
2015-12-02
17:51
MySQL Server: FULLTEXT searchVerified
(744 days)
S25.7, 5.6.29, 5.7.11, 5.7.9Ubuntu (14.04)Fulltext 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
(512 days)
S15.7Anyuse of DISTINCT with BIT and LONGTEXT leads to erroneous results  
844452017-01-09
9:29
2017-08-01
3:20
MySQL Server: DMLVerified
(337 days)
S15.7.16, 5.7.17Linuxselect distinct with constant value for left join mysql 5.7.16  
878352017-09-22
8:19
2017-09-22
10:33
MySQL Server: DMLVerified
(84 days)
S15.7.19Ubuntu (Ubuntu 16.04.2 LTS)the combination of SELECT DISTINCT and ORDER BY give wrong result for some data  
Showing all 10 (Edit, Save, CSV, Feed)