Bug #102995 | The result of AVG(REVERSE(FLOAT)) is incorrect | ||
---|---|---|---|
Submitted: | 16 Mar 2021 9:59 | Modified: | 16 Mar 2021 13:45 |
Reporter: | Guo Wenxuan | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 8.0.23 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[16 Mar 2021 9:59]
Guo Wenxuan
[16 Mar 2021 13:21]
Guo Wenxuan
Sorry, the table should be t1
[16 Mar 2021 13:45]
MySQL Verification Team
Hi Mr. wen, Thank you for your bug report. However, this is not a bug. You have applied the string function to the floating point number, which forced MySQL server to return maximum values for that type when AVG() function is applied. Not a bug.