Showing all 18 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
249112006-12-08
13:52
2008-02-07
12:45
MySQL Server: DMLWon't fix
(5895 days)
S34.1.22AnyAnysum with cast as unsigned, wrong result
296302007-07-08
19:27
2007-07-09
13:07
MySQL ServerClosed
(6108 days)
S25.0.41-community-ntWindowsAny"group by" doesnt work with subselects
291442007-06-15
16:25
2007-06-15
18:26
MySQL ServerCan't repeat
(6132 days)
S15.0+AnyAnyError on sums
314932007-10-09
21:47
2007-10-10
5:59
Connector / ODBCDuplicate
(6015 days)
S23.51Windows (2000 Server SP4, XP, Vista)AnyType Mismatch in ASP when using output from SUM in SQL statement
361382008-04-16
13:21
2008-04-25
12:06
MySQL Server: DMLNot a Bug
(5817 days)
S15.0.45AnyAnySELECT with LEFT JOIN and aggregate function returns incorrect results
339992008-01-22
22:13
2008-02-13
18:53
MySQL Server: Data TypesNot a Bug
(5889 days)
S35.0.45, 5.1.23, 6.0.5Any (Linux and Mac OS X)Anycast decimal + sum returns wrong result
376272008-06-25
11:44
2008-07-24
1:16
MySQL Server: GeneralClosed
(5727 days)
S35.1.22-rc-community x86_64, 5.1 BZRAnyAnyKilling query with sum(exists()) or avg(exists()) reproducibly crashes server
393712008-09-10
13:37
2008-09-10
15:33
Connector / ODBCClosed
(5679 days)
S15.1WindowsAnyIn powerbuilder 9 User variables does not work with aggregate functions
473552009-09-16
8:53
2009-09-16
9:19
MySQL Server: Data TypesNot a Bug
(5308 days)
S3mySQL server 4.1Windows (SP2)AnyCannot compute sum of values with 1 or 2 decimal place if type is Float.
640102012-01-12
14:01
2012-02-13
1:00
MySQL Server: GeneralNo Feedback
(4429 days)
S25.5.19 x64Linux (Ubuntu 11.10 x86_64)AnyIncorrect SUM values of Decimal data type from View results
670752012-10-04
8:56
2012-10-04
11:26
MySQL ServerNot a Bug
(4194 days)
S25.5Windows (XP SP3)AnySUM() returns an inaccurate value
323032007-11-13
2:39
2013-05-29
11:18
Connector / ODBCCan't repeat
(3957 days)
S25.1WindowsAnySum has SQL error with any Where clause, and returns no records with no Where
695902013-06-26
15:59
2018-03-14
20:53
MySQL Server: DMLClosed
(2207 days)
S35.5.32AnyAnyProblem using between with group by functions
849352017-02-10
5:08
2017-03-01
12:04
MySQL Server: JSONClosed
(2585 days)
S35.7.14, 5.7.17CentOS (Centos6.8)AnyThe result of SUM on JSON_EXTRACT lost the decimal part
986472020-02-18
13:06
2020-02-18
14:03
MySQL Server: OptimizerVerified
(1501 days)
S35.7.29Windowsx86Bad SUM result with GROUP BY
1071062022-04-23
3:09
2022-04-23
14:53
MySQL Server: DMLCan't repeat
(706 days)
S2mysql community server 8.0.22CentOSAnyUsing prepare statement, sum() results in incorrect results.
1130612023-11-13
10:23
2023-11-13
12:01
MySQL ServerDuplicate
(137 days)
S38.0.33AnyAnyThe result of avg(distinct xx)is different between from primary and secondary
1130602023-11-13
10:23
2023-11-20
11:40
MySQL Server: DMLVerified
(137 days)
S38.0AnyAnyThe result of avg(distinct xx)is different between from primary and secondary
Showing all 18 (Edit, Save, CSV, Feed)