Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.1, 10.0
-
Fix Version/s: 10.1.8
-
Component/s: Virtual Columns
-
Labels:None
-
Sprint: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' | +---------+------+------------------------------------------------------------------+
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions