Wrong result with JOINs involving Spider table

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

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

#--source ../storage/spider/mysql-test/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);

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

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

SELECT t1.* FROM t_spider AS t1 LEFT JOIN t_spider AS t2 RIGHT JOIN t_spider AS t3 ON 1 ON t1.a = 1;

# 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

#--source ../storage/spider/mysql-test/spider/include/deinit_spider.inc

SELECT t1.* FROM t_spider AS t1 LEFT JOIN t_spider AS t2 RIGHT JOIN t_spider AS t3 ON 1 ON t1.a = 1;

a

1

1

2

1

1

2

SELECT t1.* FROM t AS t1 LEFT JOIN t AS t2 RIGHT JOIN t AS t3 ON 1 ON t1.a = 1;

a

1

1

1

1

2