Bug #25512 Federated: CREATE failures
Submitted: 10 Jan 2007 0:08 Modified: 11 Jun 2008 18:15
Reporter: Peter Gulutzan Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Federated storage engine Severity:S3 (Non-critical)
Version:5.2.0 OS:Linux (SUSE 10.0 / 64-bit)
Assigned to: Ramil Kalimullin CPU Architecture:Any
Triage: D4 (Minor) / R2 (Low) / E2 (Low)

[10 Jan 2007 0:08] Peter Gulutzan
Description:
On a remote computer, I create a table with ' ' in the name.
On a local computer, I try to create a matching federated table.
It doesn't work, because spaces aren't allowed for.

On a remote computer, I create a table with 'ñ in the name.
On a local computer, I try to create a matching federated table.
It doesn't work, because n-tildes are not allowed for.

I am aware that there are reasons for this,
but the documentation says that CREATE works.
If it's hard, then just document as a limitation:
CREATE doesn't work if table name contains spaces or non-ASCII.

How to repeat:
On remote computer, say:
        USE test
        CREATE TABLE `The Rain` (s1 INT);

On local computer, say:
        USE test
        CREATE TABLE `The Rain` (s1 INT, PRIMARY KEY (s1), s2 INT)
        ENGINE=FEDERATED
        CONNECTION='mysql://Remote@192.168.1.106/test/The Rain';
        /* Change User and Host to what's appropriate for you. */

The statement will fail.

On local computer, say:
        USE test
        CREATE TABLE `The Rain` (s1 INT, PRIMARY KEY (s1), s2 INT)
        ENGINE=FEDERATED
        CONNECTION='mysql://Remote@192.168.1.106/test/`The Rain`';
        /* Change User and Host to what's appropriate for you. */

The statement will fail again.

On remote computer, say:
        SET NAMES utf8;
        USE test
        create table ñ (s1 char(5) character set ucs2);

        On local computer, say:
        SET NAMES utf8;
        create table ñ (s1 char(5) character set ucs2)
        engine=federated
        CONNECTION='mysql://Remote@192.168.1.106/test/ñ';
        /* Change User and Host to what's appropriate for you. */

The statement will fail again.
[10 Jan 2007 2:40] Miguel Solorzano
Thank you for the bug report.

local>SET NAMES utf8;
Query OK, 0 rows affected (0.00 sec)

local>        create table ñ (s1 char(5) character set ucs2)
    ->         engine=federated
    ->         CONNECTION='mysql://miguel@192.168.0.121/test/ñ';
ERROR 1434 (HY000): Can't create federated table. Foreign data src error:  error: 1146  'Table 'test.ñ' doesn't exist'