Showing all 17 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
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
1114152023-06-14
9:39
2023-06-19
14:12
MySQL Server: OptimizerVerified
(283 days)
S38.0AnyAnyCorrelated group query wrong result
1063122022-01-27
18:14
2022-02-09
13:20
MySQL Server: OptimizerVerified
(790 days)
S35.7Any (Ubuntu 20.04.3 LTS)Any (Intel(R) Core(TM) i7-10700 CPU @ 2.90GHz)Huge value in GROUP BY clause cause unexpected output
986472020-02-18
13:06
2020-02-18
14:03
MySQL Server: OptimizerVerified
(1500 days)
S35.7.29Windowsx86Bad SUM result with GROUP BY
835962016-10-28
8:06
2016-11-21
13:51
MySQL Cluster: Cluster (NDB) storage engineVerified
(2684 days)
S25.6.27-ndb-7.4.8-cluster-gplCentOS (CentOS release 6.4)Anyselect with group_concat will resturn wrong result of bit fields
804552016-02-20
23:21
2016-02-21
22:05
MySQL Server: OptimizerVerified
(2958 days)
S35.5, 5.6LinuxAnyNon-grouping field error with tables that have the same column names
711892013-12-20
14:56
2021-08-08
20:45
MySQL Server: DocumentationVerified
(3751 days)
S35.5, anyAnyAnyManual does not provide enough details on how loose index scan really works
693102013-05-23
11:47
2018-03-14
20:45
MySQL Server: DMLVerified
(3962 days)
S35.6, 5.0.97, 5.1.70, 5.5.32, 5.6.12, 5.7.2AnyAnyValid SQL statement rejected in ONLY_FULL_GROUP_BY
680722013-01-12
18:02
2013-01-13
15:08
MySQL Server: OptimizerVerified
(4092 days)
S25.1, 5.5Any (Win64, CentOS Linux)AnyMySQL 5.1 issue with timediff, group by on multiple columns, join, primary key
675292012-11-09
0:20
2017-01-09
18:55
MySQL Server: DMLVerified
(4157 days)
S35.1.41, 5.1.67, 5.5.29, 5.7.0AnyAnyGROUP BY treats +0 and -0 as different values
615682011-06-20
14:22
2011-06-25
11:30
MySQL Server: Stored RoutinesVerified
(4664 days)
S25.5.15, 5.5.13AnyAnyResult is not grouped on sequential store procedure runs
595572011-01-17
15:26
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4819 days)
S25.1, 5.5AnyAnyMySQL uses order of fields in GROUP BY when ORDER BY NULL is specified
460112009-07-07
14:05
2020-05-03
20:45
MySQL Server: OptimizerVerified
(4916 days)
S35.1-bugteamAnyAnyRegression after applying fix for bug #45828
520292010-03-13
12:26
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5120 days)
S55.1.44AnyAnyGROUP BY results in much slower query
453732009-06-08
13:14
2022-09-04
20:45
MySQL Server: OptimizerVerified
(5396 days)
S35.1.35-community, 5.1.36-bzrAnyAnyINDEX FOR GROUP BY is not used if there is a LIMIT clause in the query
429482009-02-17
23:02
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5504 days)
S55.0.67-0ubuntu6, 6.0.11Linux (Ubuntu 8.10)AnyMySQL Optimizer does not properly use Indexes on Views with "Group By"
350022008-03-03
14:17
2018-09-09
20:45
MySQL Server: DMLVerified
(5868 days)
S25.1.23-rc/5.1BK/5.0/6.0Linux (2.6.22.9-61.fc6)AnyWrong results returned when using derived table and group by
Showing all 17 (Edit, Save, CSV, Feed)