Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL)
-
None
-
10.1.8-3
Description
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.
Attachments
Issue Links
- relates to
-
-
- Closed
-
Activity
| Sprint | 10.1.8-3 [ 15 ] |
| Rank | Ranked higher |
| Fix Version/s | 10.1.8 [ 19605 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 71759 ] | MariaDB v4 [ 149649 ] |