Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.4, 10.5(EOL)
-
None
Description
Using this CLI testcase (also mentioned here):
CREATE SERVER srv FOREIGN DATA WRAPPER mysql OPTIONS (SOCKET '../socket.sock',DATABASE'',USER'',PASSWORD''); |
CREATE TABLE t2 (c INT,KEY(c)); |
INSTALL PLUGIN Spider SONAME 'ha_spider.so'; |
CREATE TABLE t (c INT,d INT,KEY(c)) ENGINE=Spider COMMENT='WRAPPER "mysql",SRV "srv",TABLE "t2",idx000 "f d"'; |
DELETE t2.* FROM t t2 WHERE (SELECT 1 FROM t); |
I get very different results on ES vs CS. On ES 10.5 we see:
|
ES 10.5.29-23 0d368ec0042a81d9549fc939fb742f82350b20ab (Optimized) Build 06/05/2025 |
10.5.29-opt>DELETE t2.* FROM t t2 WHERE (SELECT 1 FROM t);
|
ERROR 1093 (HY000): Table 't2' is specified twice, both as a target for 'DELETE' and as a separate source for data
|
And the error log shows:
|
ES 10.5.29-23 0d368ec0042a81d9549fc939fb742f82350b20ab (Optimized) Build 06/05/2025 |
2025-05-11 0:32:40 7 [Warning] Access denied for user ''@'localhost' (using password: NO)
|
On ES 11.4 we see:
|
ES 11.4.6-4 9cd12544ebfd0d52d2158af66b5aced58121cf1f (Optimized) Build 06/05/2025 |
11.4.6-opt>DELETE t2.* FROM t t2 WHERE (SELECT 1 FROM t);
|
ERROR 1429 (HY000): Unable to connect to foreign data source: srv
|
And the error log error message is also present.
On CS 10.5 we see the same client based output as ES 10.5, however there is no error message in the error log.
On CS 11.4 we see:
|
CS 11.4.6 da5a4d05b9da58705498a42b6ffa5d9211f446af (Optimized) Build 06/05/2025 |
11.4.6-opt>DELETE t2.* FROM t t2 WHERE (SELECT 1 FROM t);
|
ERROR 1176 (42000): Key 'd' doesn't exist in table 't2'
|
And the error log does not show the access denied error but shows:
|
CS 11.4.6 da5a4d05b9da58705498a42b6ffa5d9211f446af (Optimized) Build 06/05/2025 |
2025-05-11 0:40:45 4 [ERROR] Got error 1176 when reading table './test/t'
|