[MDEV-6275] spider_same_server_link not enforced - Jira

XML

Word

Printable

In this page:

for spider_same_server_link I read:

"Enable linking a table to the same local instance"

But it doesn't seem to work:

MariaDB [test]> SET @@global.spider_same_server_link = OFF;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> SET @@session.spider_same_server_link = OFF;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> CREATE OR REPLACE TABLE test.`test_base` (c INT)

    -> ENGINE = InnoDB;

Query OK, 0 rows affected (0.54 sec)

MariaDB [test]> CREATE OR REPLACE TABLE test.`test_link` (c INT)

    -> ENGINE = SPIDER

    -> COMMENT 'host "127.0.0.1", user "root", password "root", database "test", table "test_base"';

Query OK, 0 rows affected (0.12 sec)

MariaDB [test]> INSERT INTO test_link VALUES (1);

Query OK, 1 row affected (1.05 sec)

MariaDB [test]> SELECT * FROM test.test_link;

+------+

| c    |

+------+

|    1 |

+------+

1 row in set (0.00 sec)