[MDEV-21764] CONNECT table with INET6 field produces warnings upon SELECT Created: 2020-02-18  Updated: 2020-06-01  Resolved: 2020-06-01

Status: Closed
Project: MariaDB Server
Component/s: Data types, Storage Engine - Connect
Affects Version/s: 10.5
Fix Version/s: 10.5.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-274 The data type for IPv6/IPv4 addresses... Closed
relates to MDEV-20784 Testing for MDEV-274 (INET6, data typ... Closed

 Description   

create table t1 (a inet6) engine=CONNECT table_type=DOS FILE_NAME='t1.dos';
insert into t1 values ('::');
select * from t1;

10.5 41fe972d

MariaDB [test]> select * from t1;
+------+
| a    |
+------+
| ::   |
+------+
1 row in set, 2 warnings (0.000 sec)
 
MariaDB [test]> show warnings;
+---------+------+-----------------------------------------------------------------+
| Level   | Code | Message                                                         |
+---------+------+-----------------------------------------------------------------+
| Warning | 1292 | Incorrect inet6 value: '::' for column `test`.`t1`.`a` at row 1 |
| Warning | 1105 | Out of range value :: for column 'a' at row 1                   |
+---------+------+-----------------------------------------------------------------+
2 rows in set (0.000 sec)


Generated at Thu Feb 08 09:09:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.