Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.3.12, 5.5.36, 10.0.8, 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
-
None
-
None
Description
select cast('я' as int), cast('я' as time);
|
show warnings;
|
returns hex warning representation when converting to time/datetime,
and string representation when converting to the other data types:
+-------------------+--------------------+
|
| cast('я' as int) | cast('я' as time) |
|
+-------------------+--------------------+
|
| 0 | 00:00:00 |
|
+-------------------+--------------------+
|
1 row in set, 2 warnings (0.00 sec)
|
|
|
+---------+------+--------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+--------------------------------------------+
|
| Warning | 1292 | Truncated incorrect INTEGER value: 'я' |
|
| Warning | 1292 | Truncated incorrect time value: '\xD1\x8F' |
|
+---------+------+--------------------------------------------+
|
2 rows in set (0.00 sec)
|
It should be fixed to print string representation in both cases.
Attachments
Issue Links
- relates to
-
-
- Closed
-