Bug #79568 | varchar convert to int | ||
---|---|---|---|
Submitted: | 9 Dec 2015 7:48 | Modified: | 9 Dec 2015 11:06 |
Reporter: | H jake | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.6.27 and above | OS: | Linux |
Assigned to: | CPU Architecture: | Any |
[9 Dec 2015 7:48]
H jake
[9 Dec 2015 11:06]
MySQL Verification Team
Thank you for the bug report. Please read: http://dev.mysql.com/doc/refman/5.6/en/type-conversion.html "If both arguments in a comparison operation are strings, they are compared as strings. " ..... " Comparisons that use floating-point numbers (or values that are converted to floating-point numbers) are approximate because such numbers are inexact. This might lead to results that appear inconsistent: mysql> SELECT '18015376320243458' = 18015376320243458; -> 1 mysql> SELECT '18015376320243459' = 18015376320243459; -> 0 "