Showing all 21 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
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
1131352023-11-20
3:03
2023-11-20
15:34
MySQL Server: DMLVerified
(388 days)
S38.0AnyAnyDISTINCT JOIN ORDER BY statements ignore ORDER BY when tmp_table_size is small
1093632022-12-13
13:08
2022-12-16
14:50
MySQL Server: OptimizerVerified
(727 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
(729 days)
S35.7.22, 8.0.31AnyAnyvalue changed caused by DISTINCT and JOIN
1093622022-12-13
12:55
2022-12-13
13:20
MySQL Server: OptimizerVerified
(730 days)
S28.0.13, 8.0.31AnyAnyExtra line caused by DISTINCT and key
1093562022-12-13
7:01
2022-12-13
7:56
MySQL Server: OptimizerVerified
(730 days)
S28.0.16, 8.0.31AnyAnyExtra line caused by DISTINCT and IS TRUE
1093542022-12-13
5:43
2022-12-13
7:15
MySQL Server: OptimizerVerified
(730 days)
S38.0.21, 8.0.30, 8.0.31AnyAnyNumeric format change caused by DISTINCT, UNION and NULL
1089362022-10-31
12:58
2022-12-13
3:56
MySQL Server: OptimizerVerified
(730 days)
S28.0.30AnyAnyValue change caused by DISTINCT
1089462022-11-01
3:35
2022-12-13
4:12
MySQL Server: OptimizerVerified
(730 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
(730 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
(730 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
(730 days)
S28.0.22, 8.0.31AnyAnyExtra line caused by DISTINCT and a certain number of '0'
1091552022-11-22
5:43
2023-12-13
11:44
MySQL Server: OptimizerVerified
(751 days)
S58.0.18, 8.0.31, 8.0.35AnyAnyInvalid scan on left join tables of which columns not in distinct output fields
914182018-06-26
7:08
2018-09-07
13:32
MySQL Server: OptimizerVerified
(2361 days)
S35.7,8.0.11, 5.7.22AnyAnyderived_merge causing inccorect results with distinct subquery and uuid()
878352017-09-22
8:19
2018-12-19
1:41
MySQL Server: DMLVerified
(2638 days)
S15.7.19Ubuntu (Ubuntu 16.04.2 LTS)Anythe combination of SELECT DISTINCT and ORDER BY give wrong result for some data
823082016-07-21
14:54
2023-07-31
15:25
MySQL Server: MyISAM storage engineVerified
(3066 days)
S15.7AnyAnyuse of DISTINCT with BIT and LONGTEXT leads to erroneous results
794972015-12-02
16:41
2015-12-02
17:51
MySQL Server: FULLTEXT searchVerified
(3298 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
304022007-08-14
8:35
2014-03-10
14:31
MySQL Server: DMLVerified
(4390 days)
S25.0.37 CommunityLinux (RedHat 9.0)AnySELECT count(distinct) from mytable return 0
657922012-07-03
2:19
2012-07-04
9:54
MySQL Server: OptimizerVerified
(4545 days)
S55.1,5.5AnyAnyan unecessary Using temporary in distinct query
383972008-07-27
20:13
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5981 days)
S35.1.26, 5.0.62AnyAnyselect distinct + order by desc is executed inefficiently
Showing all 21 (Edit, Save, CSV, Feed)