# This may not work, e.g. for in-source builds, fix the path

--source plugin/spider/spider/include/init_spider.inc

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 TABLE t (a INT);

INSERT INTO t VALUES (1),(2);

CREATE TABLE t_spider (a INT) ENGINE=SPIDER COMMENT = "wrapper 'mysql', srv 's', table 't'";

SELECT a FROM t_spider WHERE a IN ( SELECT a FROM t_spider );

# Cleanup

DROP TABLE t_spider, t;

DROP SERVER s;

This may not work, e.g. for in-source builds, fix the path

--source plugin/spider/spider/include/deinit_spider.inc

mysqltest: At line 12: query 'SELECT a FROM t_spider WHERE a IN ( SELECT a FROM t_spider )' failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '`test`.`t` t1 where 1' at line 1

select t0.`a` `a` from `test`.`t` t0`test`.`t` t1 where 1