-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.5, 10.1, 10.0
-
Fix Version/s: 10.1.8
-
Component/s: OTHER
-
Labels:None
-
Sprint:10.1.8-3
This SQL script:
SELECT 'x' << 1, CAST('x' AS DOUBLE), CAST('x' AS DECIMAL);
|
SHOW WARNINGS;
|
returns the following warnings:
+---------+------+----------------------------------------+
|
| Level | Code | Message |
|
+---------+------+----------------------------------------+
|
| Warning | 1292 | Truncated incorrect INTEGER value: 'x' |
|
| Warning | 1292 | Truncated incorrect DOUBLE value: 'x' |
|
| Warning | 1292 | Truncated incorrect DECIMAL value: 'x' |
|
+---------+------+----------------------------------------+
|
Now if I use MAX:
SELECT MAX('x') << 1, CAST(MAX('x') AS DOUBLE), CAST(MAX('x') AS DECIMAL);
|
it returns no warnings.
- relates to
-
MDEV-8806 Numeric CAST produce different warnings for strings literals vs functions
-
- Closed
-