Showing all 18 (Edit, Save, CSV, Feed) |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
24911 | 2006-12-08 13:52 | 2008-02-07 12:45 | MySQL Server: DML | Won't fix (5895 days) | S3 | 4.1.22 | Any | Any | sum with cast as unsigned, wrong result |
29630 | 2007-07-08 19:27 | 2007-07-09 13:07 | MySQL Server | Closed (6108 days) | S2 | 5.0.41-community-nt | Windows | Any | "group by" doesnt work with subselects |
29144 | 2007-06-15 16:25 | 2007-06-15 18:26 | MySQL Server | Can't repeat (6132 days) | S1 | 5.0+ | Any | Any | Error on sums |
31493 | 2007-10-09 21:47 | 2007-10-10 5:59 | Connector / ODBC | Duplicate (6015 days) | S2 | 3.51 | Windows (2000 Server SP4, XP, Vista) | Any | Type Mismatch in ASP when using output from SUM in SQL statement |
36138 | 2008-04-16 13:21 | 2008-04-25 12:06 | MySQL Server: DML | Not a Bug (5817 days) | S1 | 5.0.45 | Any | Any | SELECT with LEFT JOIN and aggregate function returns incorrect results |
33999 | 2008-01-22 22:13 | 2008-02-13 18:53 | MySQL Server: Data Types | Not a Bug (5889 days) | S3 | 5.0.45, 5.1.23, 6.0.5 | Any (Linux and Mac OS X) | Any | cast decimal + sum returns wrong result |
37627 | 2008-06-25 11:44 | 2008-07-24 1:16 | MySQL Server: General | Closed (5727 days) | S3 | 5.1.22-rc-community x86_64, 5.1 BZR | Any | Any | Killing query with sum(exists()) or avg(exists()) reproducibly crashes server |
39371 | 2008-09-10 13:37 | 2008-09-10 15:33 | Connector / ODBC | Closed (5679 days) | S1 | 5.1 | Windows | Any | In powerbuilder 9 User variables does not work with aggregate functions |
47355 | 2009-09-16 8:53 | 2009-09-16 9:19 | MySQL Server: Data Types | Not a Bug (5308 days) | S3 | mySQL server 4.1 | Windows (SP2) | Any | Cannot compute sum of values with 1 or 2 decimal place if type is Float. |
64010 | 2012-01-12 14:01 | 2012-02-13 1:00 | MySQL Server: General | No Feedback (4429 days) | S2 | 5.5.19 x64 | Linux (Ubuntu 11.10 x86_64) | Any | Incorrect SUM values of Decimal data type from View results |
67075 | 2012-10-04 8:56 | 2012-10-04 11:26 | MySQL Server | Not a Bug (4194 days) | S2 | 5.5 | Windows (XP SP3) | Any | SUM() returns an inaccurate value |
32303 | 2007-11-13 2:39 | 2013-05-29 11:18 | Connector / ODBC | Can't repeat (3957 days) | S2 | 5.1 | Windows | Any | Sum has SQL error with any Where clause, and returns no records with no Where |
69590 | 2013-06-26 15:59 | 2018-03-14 20:53 | MySQL Server: DML | Closed (2207 days) | S3 | 5.5.32 | Any | Any | Problem using between with group by functions |
84935 | 2017-02-10 5:08 | 2017-03-01 12:04 | MySQL Server: JSON | Closed (2585 days) | S3 | 5.7.14, 5.7.17 | CentOS (Centos6.8) | Any | The result of SUM on JSON_EXTRACT lost the decimal part |
98647 | 2020-02-18 13:06 | 2020-02-18 14:03 | MySQL Server: Optimizer | Verified (1501 days) | S3 | 5.7.29 | Windows | x86 | Bad SUM result with GROUP BY |
107106 | 2022-04-23 3:09 | 2022-04-23 14:53 | MySQL Server: DML | Can't repeat (706 days) | S2 | mysql community server 8.0.22 | CentOS | Any | Using prepare statement, sum() results in incorrect results. |
113061 | 2023-11-13 10:23 | 2023-11-13 12:01 | MySQL Server | Duplicate (137 days) | S3 | 8.0.33 | Any | Any | The result of avg(distinct xx)is different between from primary and secondary |
113060 | 2023-11-13 10:23 | 2023-11-20 11:40 | MySQL Server: DML | Verified (137 days) | S3 | 8.0 | Any | Any | The result of avg(distinct xx)is different between from primary and secondary |
Showing all 18 (Edit, Save, CSV, Feed) |