Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5
-
None
Description
CREATE OR REPLACE TABLE t1 (a INET6); |
INSERT INTO t1 VALUES ('2001:db8::ff00:42:8329'); |
SELECT CAST(a AS BINARY(16)) FROM t1; |
SHOW WARNINGS;
|
+-----------------------+
|
| CAST(a AS BINARY(16)) |
|
+-----------------------+
|
| 2001:db8::ff00:4 |
|
+-----------------------+
|
+---------+------+----------------------------------------------------------------+ |
| Level | Code | Message | |
+---------+------+----------------------------------------------------------------+ |
| Warning | 1292 | Truncated incorrect BINARY(16) value: '2001:db8::ff00:42:8329' | |
+---------+------+----------------------------------------------------------------+ |
Notice: it returned text address representation with a truncation warning.
The expected result is to return binary address representation without warnings.
Attachments
Issue Links
- relates to
-
-
- Closed
-