Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
--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 t1 (a int) ENGINE=MyISAM; |
CREATE TABLE t2 (b int) ENGINE=MyISAM; |
CREATE TABLE t1_spider (a int) ENGINE=SPIDER COMMENT = "wrapper 'mysql', srv 's', table 't1'"; |
|
SELECT * FROM t1_spider LEFT JOIN t2 ON a = b WHERE b = 3 OR a = 4; |
|
# Cleanup
|
|
DROP TABLE t1_spider, t1, t2; |
DROP SERVER s; |
|
--source plugin/spider/spider/include/deinit_spider.inc |
10.3 ce23802c |
mysqltest: At line 10: query 'SELECT * FROM t1_spider LEFT JOIN t2 ON a = b WHERE b = 3 OR a = 4' failed: 1041: Out of memory. |
Reproducible on all of 10.3-10.10, with MyISAM or Aria for the joining table.