| Bug #98806 | Please update type conversion in expressions manual | ||
|---|---|---|---|
| Submitted: | 2 Mar 2020 19:31 | Modified: | 11 Mar 2020 13:14 |
| Reporter: | Domas Mituzas | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
| Version: | 5.6, 8.0 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[2 Mar 2020 22:19]
MySQL Verification Team
Thank you for the bug report.
[11 Mar 2020 13:14]
Paul DuBois
Posted by developer: At https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html replaced example with one that does show the type-conversion issue. Also revised some of the surrounding text.
Description: manual sections that refer to type conversions are incorrect, e.g. " mysql> SELECT '18015376320243458' = 18015376320243458; -> 1 mysql> SELECT '18015376320243459' = 18015376320243459; -> 0 " both statements will evaluate to true on both 5.6 and 8.0 - as the integer constant is NEWDECIMAL and not float. How to repeat: SELECT '18015376320243459' = 18015376320243459; compare with manual Suggested fix: review manual for correctness