different name and mapping columns

[nghia nguyen]

Can federated table columns have different name and mapping to remote table?
I mean, for ex: the remote table like this
CREATE TABLE test_table (
id INT(20) NOT NULL AUTO_INCREMENT,
name VARCHAR(32) NOT NULL DEFAULT '',
);
and the federated table lile this
CREATE TABLE federated_table (
id INT(20) NOT NULL AUTO_INCREMENT,
username VARCHAR(32) NOT NULL DEFAULT '' mapping name,
)
ENGINE=FEDERATED
DEFAULT CHARSET=latin1
CONNECTION='mysql://fed_user@remote_host:9306/federated/test_table';

--> The username column in federated table mapping to name column in remote table.
Nghia