Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
Description
INSTALL PLUGIN Spider SONAME 'ha_spider.so'; |
CREATE USER Spider@localhost IDENTIFIED BY 'PWD1'; |
CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock',DATABASE 'test',user 'Spider',PASSWORD 'PWD1'); |
CREATE TABLE t (c INT) ENGINE=InnoDB; |
CREATE TABLE ts (c1 INT) ENGINE=Spider COMMENT='WRAPPER "mysql",srv "srv",TABLE "t"'; |
SELECT c1 FROM ts; |
Leads to:
10.11.0 6ebdd3013a18b01dbecec76b870810329eb76586 (Debug) |
10.11.0-dbg>SELECT c1 FROM ts;
|
ERROR 1054 (42S22): Unknown column 't0.c1' in 'field list'
|
1. The t0 is incorrect, there is no t0 defined. This is likely a Spider-internal reference.
2. The error is confusing. We could replace it with something like:
ERROR 1054 (42S22): Unknown column 'c1' in parent spider table 't'.
|
Or similar (assuming that this is the underlaying issue).
Changing the definition of table t to column name c1 (instead of c) fixes the issue.
Attachments
Issue Links
- duplicates
-
MDEV-29430 'Got error 1054 when reading table' on SELECT (Spider)
- Closed
- relates to
-
MDEV-29664 Assertion `!n_mysql_tables_in_use' failed in innobase_close_connection
- Closed