install soname 'ha_federatedx';

create table t1 (a inet6);

insert into t1 values ('::'),('f::f');

eval create table t2 (a inet6) engine=federated connection='mysql://root@127.0.0.1:$MASTER_MYPORT/test/t1';

select * from t2;

# cleanup

drop table t1, t2;

uninstall soname 'ha_federatedx';

select * from t2;

a

NULL

NULL

Warnings:

Warning	1292	Incorrect inet6 value: '::' for column `test`.`t2`.`a` at row 1

Warning	1292	Incorrect inet6 value: 'f::f' for column `test`.`t2`.`a` at row 2

create table t1 (a binary(16));

insert into t1 values ('::'),('f::f');

create table t2 (a binary(16)) engine=federated connection='mysql://root@127.0.0.1:16000/test/t1';

select * from t2;

a

::

f::f