--source include/have_innodb.inc

install soname 'ha_spider';

set spider_same_server_link= on;

eval create server s foreign data wrapper mysql options 

(host '127.0.0.1', database 'test', user 'root', port $MASTER_MYPORT);

create or replace table t (id int primary key) engine=InnoDB;

create or replace table t_sp (id int, key(id desc)) engine=Spider COMMENT='wrapper "mysql", srv "s", table "t"';

select * from t_sp;

show create table t_sp;

show create table t_sp;

Table	Create Table

t_sp	CREATE TABLE `t_sp` (

  `id` int(11) DEFAULT NULL,

  KEY `id` (`id` DESC)

) ENGINE=SPIDER DEFAULT CHARSET=latin1 COMMENT='wrapper "mysql", srv "s", table "t"'