Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
N/A
Description
The test runs for MDEV-28856 have been difficult to analyze as there are many offsets between the base (pre-patch) run and the patch.
Part or all of the issues seem to come from this difference:
INSTALL PLUGIN Spider SONAME 'ha_spider.so'; |
CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '',DATABASE '',USER '',PASSWORD ''); |
CREATE TABLE t (c INT) ENGINE=Spider COMMENT="srv 'srv', table 't'"; |
Leads to:
|
preview-11.3-preview 465f9beea1c43a1dad74330aa2dc30927bc224f5 (Debug and Optimized) |
11.3.0-dbg>INSTALL PLUGIN Spider SONAME 'ha_spider.so';
|
Query OK, 0 rows affected, 1 warning (0.025 sec)
|
|
|
11.3.0-dbg>CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '',DATABASE '',USER '',PASSWORD '');
|
Query OK, 0 rows affected (0.001 sec)
|
|
|
11.3.0-dbg>CREATE TABLE t (c INT) ENGINE=Spider COMMENT="srv 'srv', table 't'";
|
ERROR 12501 (HY000): The connect info 'MYSQL' is invalid
|
The above is also the behavior of 11.3 trunk. Versus (latest patch branch):
|
bb-11.3-mdev-28856-and-fixes cc08a83ef4225960dccb46bd68fc549160d21841 (Debug) |
11.3.0-dbg>INSTALL PLUGIN Spider SONAME 'ha_spider.so';
|
Query OK, 0 rows affected, 1 warning (0.023 sec)
|
|
|
11.3.0-dbg>CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '',DATABASE '',USER '',PASSWORD '');
|
Query OK, 0 rows affected (0.002 sec)
|
|
|
11.3.0-dbg>CREATE TABLE t (c INT) ENGINE=Spider COMMENT="srv 'srv', table 't'";
|
Query OK, 0 rows affected (0.090 sec)
|
Removing the circular reference by using something like:
INSTALL PLUGIN Spider SONAME 'ha_spider.so'; |
CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '',DATABASE '',USER '',PASSWORD ''); |
CREATE TABLE t1 (c INT) ENGINE=InnoDB; |
CREATE TABLE t (c INT) ENGINE=Spider COMMENT="srv 'srv', table 't1'"; |
Makes no difference.
Attachments
Issue Links
- relates to
-
MDEV-28856 Spider: Implement more engine-defined options
-
- Closed
-