Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0, 10.1
-
None
-
10.1.8-3
Description
SET @aaa = COLUMN_CREATE('price', 0xF0F1F2F3F4F5F6F7);
|
SELECT COLUMN_GET(@aaa, 'price' AS DECIMAL) aaa;
|
SHOW WARNINGS;
|
returns this warning:
+---------+------+---------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+---------------------------------------------------------+
|
| Warning | 1918 | Encountered illegal value '' when converting to DECIMAL |
|
+---------+------+---------------------------------------------------------+
|
Notice, the empty string in the warning text, instead of the actual data.
The expected result it to escape unreadable data, like it's done everything else, e.g:
SELECT _binary 0xF1F2F3F4F5F6F7 + 0;
|
SHOW WARNINGS;
|
+---------+------+------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+------------------------------------------------------------------+
|
| Warning | 1292 | Truncated incorrect DOUBLE value: '\xF1\xF2\xF3\xF4\xF5\xF6\xF7' |
|
+---------+------+------------------------------------------------------------------+
|