[#MDEV-32557] "ERROR 12501 (HY000): The connect info 'MYSQL' is invalid" not repeatable in MDEV-28856 branch

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.

[MDEV-32557] "ERROR 12501 (HY000): The connect info 'MYSQL' is invalid" not repeatable in MDEV-28856 branch Created: 2023-10-24 Updated: 2023-10-24 Resolved: 2023-10-24
Status:	Closed
Project:	MariaDB Server
Component/s:	Storage Engine - Spider
Affects Version/s:	N/A
Fix Version/s:	N/A

[MDEV-32557] "ERROR 12501 (HY000): The connect info 'MYSQL' is invalid" not repeatable in MDEV-28856 branch Created: 2023-10-24 Updated: 2023-10-24 Resolved: 2023-10-24