Does federated engine allows table creation for ipv6 ?

[tarun gupta]

I have two server both connected to each other by ipv6.

1 can i create table on local server with ipv6 connection of remote server

What i have tried

1 i created a table on remote server which is on ipv6

2 i created a table on local server which is on ipv6 with connection details of
remote server as mentioned below :

This is how i created my local table

CREATE TABLE usageinfo
(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(200) NULL,
controllerId VARCHAR(200) NULL,
slotId VARCHAR(200) NULL,
startdate DATE NULL,
starttime TIME NULL,
enddate DATE NULL,
endtime TIME NULL
)ENGINE=FEDERATED
CONNECTION='mysql://username:password@2222:2222:2:240a::10/dbName/usageinfo';

table created successfully.

After i perform select query got the below error :

ERROR 1429 (HY000): Unable to connect to foreign data source: Can't connect to MySQL server on '2222'

I believe ipv6 format that i have specified while creating table is incorrect.

can some one help me with the correct ipv6 format.

or let me know if ipv6 is not supported for federated engine.