|
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';
|
|
10.5 5e17b1f7
|
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
|
It works with binary instead of inet6:
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
|
|