Bug #103192 | Wrong result of execute prepare on 'smallint' | ||
---|---|---|---|
Submitted: | 2 Apr 2021 7:24 | Modified: | 12 Apr 2021 22:27 |
Reporter: | Guo Wenxuan | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S2 (Serious) |
Version: | 8.0.23 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[2 Apr 2021 7:24]
Guo Wenxuan
[2 Apr 2021 9:31]
MySQL Verification Team
Thank you for the bug report.
[12 Apr 2021 22:27]
Jon Stephens
Documented fix as follows in the MySQL 8.0.25 changelog: For a prepared, implicitly grouped SELECT statement in which the WHERE clause was determined to be always false, the result of some aggregate functions could sometimes be picked up from the previous execution of the statement. Closed.