Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0.11
-
Fix Version/s: 10.4.6
-
Component/s: Storage Engine - Spider
-
Labels:
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) |