Bug #95889 | Functional index seems to malfunction with UNSIGNED column | ||
---|---|---|---|
Submitted: | 19 Jun 2019 22:08 | Modified: | 20 Aug 2019 2:59 |
Reporter: | Manuel Rigger | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
Version: | 8.0.16 | OS: | Ubuntu |
Assigned to: | CPU Architecture: | x86 |
[19 Jun 2019 22:08]
Manuel Rigger
[20 Jun 2019 5:37]
MySQL Verification Team
Hello Manuel Rigger, Thank you for the report. regards, Umesh
[20 Aug 2019 2:59]
Jon Stephens
Documented fix as follows in the MySQL 8.0.18 changelog: Using a function such as IFNULL() or ABS() in a functional index led to the error -Value is out of range for functional index...- when an UNSIGNED column used as an argument to such a function held a value exceeding that of the corresponding signed integer type. Closed.