Error on "SELECT *"

[Barry Webb]

Hello,

I have just started playing with the Federated storage engine. I have set up two servers as follows:

1. Main Server (MySQL 5.0.19-max)
2. Remote Server (MySQL 4.1.16)

I have set up a database and table on the remote server, then I set up a Federated table on the main server that points to the table on the remote server. Everything seems to be fine up to this point. Then, I run the query "SELECT * FROM Test" on the main server and I get the error :

ERROR 1146: Table 'fed_test.1' doesn't exist

I get the same error on another Federated table (pointing to another server). fed_test is the name of the local database. I am not sure what the table '1' is.

Any help will be gratefully received as I am completely stuck at the moment.

Thanks,
Baz