Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.11
Description
In this page:
https://mariadb.com/kb/en/spider-server-system-variables/
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) |