Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.1, 11.2, 11.4, 11.5, 11.6
-
None
Description
POC:
INSTALL PLUGIN Spider SONAME 'ha_spider.so'; |
CREATE TABLE t (c INT) ENGINE=Spider COMMENT='wrapper "mysql", SOCKET "../socket.sock", user "root", database "test"'; |
INSERT INTO t VALUES (1); |
Leads to:
10.5.26 b8f92ade57691a78cc97c5d79eae0a27a10cb8f2 (Optimized) |
10.5.26-opt>INSERT INTO t VALUES (1);
|
ERROR 12719 (HY000): An infinite loop is detected when opening table test.t
|
However, for partitions we see:
INSTALL PLUGIN Spider SONAME 'ha_spider.so'; |
CREATE TABLE t (c INT) ENGINE=Spider COMMENT='wrapper "mysql", SOCKET "../socket.sock", user "root", database "test"' PARTITION BY RANGE (c) (PARTITION p VALUES LESS THAN (10)); |
INSERT INTO t VALUES (1); |
Leads to:
10.5.26 b8f92ade57691a78cc97c5d79eae0a27a10cb8f2 (Optimized) |
10.5.26-opt>INSERT INTO t VALUES (1);
|
ERROR 12702 (HY000): Remote table 'test.t#P#p' is not found
|
Indicating that Spider is still looking for the table rather than detecting the infinite loop.
Attachments
Issue Links
- relates to
-
MDEV-34675 ERROR 12702 (HY000): Remote table 'test.t#P#p' is not found on INSERT when using partitioning with invalid credentials or invalid socket
-
- Open
-