Showing all 21 (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
(4019 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
(5610 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
(4174 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
(2927 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		2023-07-31
15:25		MySQL Server: MyISAM storage engineVerified
(2695 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
(2267 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
(1990 days)		S35.7,8.0.11, 5.7.22AnyAnyderived_merge causing inccorect results with distinct subquery and uuid()
1091552022-11-22
5:43		2022-11-22
6:36		MySQL Server: OptimizerVerified
(380 days)		S58.0.18, 8.0.31AnyAnyInvalid scan on left join tables of which columns not in distinct output fields
1089362022-10-31
12:58		2022-12-13
3:56		MySQL Server: OptimizerVerified
(359 days)		S28.0.30AnyAnyValue change caused by DISTINCT
1089462022-11-01
3:35		2022-12-13
4:12		MySQL Server: OptimizerVerified
(359 days)		S38.0.30AnyAny0 changed to 0.0 caused by DISTINCT and UNION ALL
1093512022-12-13
4:46		2022-12-13
6:35		MySQL Server: OptimizerVerified
(359 days)		S28.0.28, 8.0.31AnyAnyValue change caused by DISTINCT and date functions
1093522022-12-13
5:00		2022-12-13
6:43		MySQL Server: OptimizerVerified
(359 days)		S38.0.23, 8.0.31AnyAnyNumeric format change caused by DISTINCT and UCASE
1093532022-12-13
5:24		2022-12-13
7:12		MySQL Server: OptimizerVerified
(359 days)		S28.0.22, 8.0.31AnyAnyExtra line caused by DISTINCT and a certain number of '0'
1093542022-12-13
5:43		2022-12-13
7:15		MySQL Server: OptimizerVerified
(359 days)		S38.0.21, 8.0.30, 8.0.31AnyAnyNumeric format change caused by DISTINCT, UNION and NULL
1093562022-12-13
7:01		2022-12-13
7:56		MySQL Server: OptimizerVerified
(359 days)		S28.0.16, 8.0.31AnyAnyExtra line caused by DISTINCT and IS TRUE
1093622022-12-13
12:55		2022-12-13
13:20		MySQL Server: OptimizerVerified
(359 days)		S28.0.13, 8.0.31AnyAnyExtra line caused by DISTINCT and key
1093672022-12-13
16:11		2022-12-14
5:58		MySQL Server: OptimizerVerified
(358 days)		S35.7.22, 8.0.31AnyAnyvalue changed caused by DISTINCT and JOIN
1093632022-12-13
13:08		2022-12-16
14:50		MySQL Server: OptimizerVerified
(356 days)		S38.0.4, 8.0.31AnyAny0 changed to -0 caused by DISTINCT and UNION ALL
1131352023-11-20
3:03		2023-11-20
15:34		MySQL Server: DMLVerified
(17 days)		S38.0AnyAnyDISTINCT JOIN ORDER BY statements ignore ORDER BY when tmp_table_size is small
Showing all 21 (Edit, Save, CSV, Feed)