MySQL Forums
Forum List  »  Federated Storage Engine

truncated connect string
Posted by: off mct
Date: September 21, 2005 02:43AM

It seems that the connect string is truncated when using the federated tables.

I have a table host apple:
CREATE TABLE `TableWithAVeryVeryLongTableName` (
`a` varchar(100) NOT NULL default '',
`b` varchar(100) NOT NULL default ''
) TYPE=MyIsam;

Then I created this federated table:
CREATE TABLE `TableWithAVeryVeryLongTableName` (
`a` varchar(100) NOT NULL default '',
`b` varchar(100) NOT NULL default ''
) ENGINE=FEDERATED
COMMENT='mysql://uname:passwd@apple/test/TableWithAVeryVeryLongTableName';

I got the error:
ERROR 1434: Can't create federated table. Foreign data src error : ': 1146 : Table 'test.TableWithAVeryVeryLongTableN' doesn't exist'

I had to create a user with a short username and password to make it work so that my new DDL is:
CREATE TABLE `TableWithAVeryVeryLongTableName` (
`a` varchar(100) NOT NULL default '',
`b` varchar(100) NOT NULL default ''
) ENGINE=FEDERATED
COMMENT='mysql://u:p@apple/test/TableWithAVeryVeryLongTableName';

It worked but is there another way to it besides my workaround?

Options: ReplyQuote


Subject
Views
Written By
Posted
truncated connect string
4186
September 21, 2005 02:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.