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
(4332 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
(5923 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
(4487 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
(3240 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
(3008 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
(2580 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
(2303 days)
S35.7,8.0.11, 5.7.22AnyAnyderived_merge causing inccorect results with distinct subquery and uuid()
1089362022-10-31
12:58
2022-12-13
3:56
MySQL Server: OptimizerVerified
(672 days)
S28.0.30AnyAnyValue change caused by DISTINCT
1089462022-11-01
3:35
2022-12-13
4:12
MySQL Server: OptimizerVerified
(672 days)
S38.0.30AnyAny0 changed to 0.0 caused by DISTINCT and UNION ALL
1091552022-11-22
5:43
2023-12-13
11:44
MySQL Server: OptimizerVerified
(693 days)
S58.0.18, 8.0.31, 8.0.35AnyAnyInvalid scan on left join tables of which columns not in distinct output fields
1093512022-12-13
4:46
2022-12-13
6:35
MySQL Server: OptimizerVerified
(672 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
(672 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
(672 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
(672 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
(672 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
(672 days)
S28.0.13, 8.0.31AnyAnyExtra line caused by DISTINCT and key
1093632022-12-13
13:08
2022-12-16
14:50
MySQL Server: OptimizerVerified
(669 days)
S38.0.4, 8.0.31AnyAny0 changed to -0 caused by DISTINCT and UNION ALL
1093672022-12-13
16:11
2022-12-14
5:58
MySQL Server: OptimizerVerified
(671 days)
S35.7.22, 8.0.31AnyAnyvalue changed caused by DISTINCT and JOIN
1131352023-11-20
3:03
2023-11-20
15:34
MySQL Server: DMLVerified
(330 days)
S38.0AnyAnyDISTINCT JOIN ORDER BY statements ignore ORDER BY when tmp_table_size is small
Showing all 21 (Edit, Save, CSV, Feed)