Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11144

create federated table command error

    XMLWordPrintable

    Details

      Description

      I create some federated tables like below command.

      CREATE SERVER 'remote' FOREIGN DATA WRAPPER 'mysql' OPTIONS
      (HOST 'IP address',
       DATABASE 'dbname',
       USER 'root',
       PASSWORD 'password',
       PORT 3306,
       SOCKET '',
       OWNER 'root');
       
      CREATE TABLE "table_name" (
      ....
      ) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='remote';
      

      Already I created 266 tables, I want to create some more tables.
      But I got a error message.

      ##############################################
      Lookup Error - MySQL Database Error: Can't create federated table. Foreign data src error:  database: 'dbname'  username: 'root'  hostname: 'ip address'
      ##############################################
      

      Already created tables are useable but the new create table command is error.
      What's wrong?

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            jisun jisun bae
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration