Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.2, 11.4, 11.6, 11.7
-
None
Description
--source plugin/spider/spider/include/init_spider.inc
|
SET spider_same_server_link=on; |
eval CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (HOST "127.0.0.1", DATABASE "test", USER "root", PORT $MASTER_MYPORT); |
CREATE TABLE t (c INT KEY,c1 INT,c2 INT); |
INSERT INTO t VALUES (0,1,0),(1,0,0),(2,0,0); |
CREATE TABLE t1 (c1 INT,c2 INT,c3 INT,PRIMARY KEY(c1),UNIQUE INDEX (c2)) ENGINE=Spider COMMENT='WRAPPER "mysql",SRV "srv",TABLE "t"'; |
--error ER_BAD_FIELD_ERROR
|
SELECT * FROM t1 WHERE c1='' OR c2='' HAVING COUNT(*)=1; |
Leads to:
CS 11.2.6 e91a79945822def1452787f825e6047c6a64dbd9 (Debug) |
[ERROR] Got error 128 when reading table './test/t1'
|
In the error log (see var/log/mysqld.1.err after MTR replay)