Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 11.8, 12.3
-
None
-
None
Description
INSTALL SONAME 'ha_federatedx'; |
|
--eval create server fedlink foreign data wrapper mysql options (host "127.0.0.1", database "test", user "root", port $MASTER_MYPORT)
|
|
CREATE TABLE t AS SELECT 1 AS a; |
CREATE TABLE fed_t (a INT) ENGINE=FEDERATED CONNECTION = 'fedlink/t'; |
|
|
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test'; |
DROP TABLE t; |
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test'; |
|
|
DROP TABLE fed_t; |
DROP SERVER fedlink; |
UNINSTALL SONAME 'ha_federatedx'; |
|
main 685e0f8170a6da1c35e110c9016e8fa7859e6c54 |
mysqltest: At line 10: query 'SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test'' failed: ER_NO_SUCH_TABLE (1146): Received error: 1146 : Remote table does not exist
|
The problem is not only that the query fails as such, but also that it doesn't say which table is guilty, so there is no easy way to fix the problem.
The error is specific to FederatedX, with Federated the query from I_S works.
Attachments
Issue Links
- relates to
-
MDEV-25824 Federated table with unavailable remote causes unexpected errors
-
- Open
-
-
MDEV-29956 Confusing error or warning upon querying information schema when remote of federated is unreachable
-
- Open
-