CREATE DATABASE spider_test;

GRANT ALL PRIVILEGES ON spider_test.* TO spider_test@'%' IDENTIFIED BY 'password';

USE spider_test;

CREATE TABLE local_tab (

   id int auto_increment primary key,

   str varchar(50)

) ENGINE=InnoDB;

CREATE SERVER srv1 

  FOREIGN DATA WRAPPER mysql 

OPTIONS( 

  HOST '172.30.0.249', 

  DATABASE 'spider_test',

  USER 'spider_test',

  PASSWORD 'password'

);

CREATE DATABASE spider_test;

USE spider_test;

CREATE TABLE spider_tab (

   id int auto_increment primary key,

   str varchar(50)

) ENGINE=Spider COMMENT='wrapper "mysql", srv "srv1" table "local_tab"';

MariaDB [spider_test]> CREATE TABLE spider_tab (

    ->    id int auto_increment primary key,

    ->    str varchar(50)

    -> ) ENGINE=Spider COMMENT='wrapper "mysql", srv "srv1" table "local_tab"';

Query OK, 0 rows affected (0.01 sec)

MariaDB [spider_test]> SELECT * FROM spider_tab;

ERROR 12702 (HY000): Remote table 'spider_test.spider_tab' is not found