[MDEV-6275] spider_same_server_link not enforced Created: 2014-05-27  Updated: 2019-06-14  Resolved: 2019-06-12

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.0.11
Fix Version/s: 10.4.6

Type: Bug Priority: Major
Reporter: Federico Razzoli Assignee: Kentoku Shiba (Inactive)
Resolution: Fixed Votes: 0
Labels: spider


 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)



 Comments   
Comment by Kentoku Shiba (Inactive) [ 2019-06-10 ]

willhan
I added a check for this parameter. Would you please check it?
7ea0afd

Comment by willhan [ 2019-06-11 ]

Hi Kentoku
It's ok,
and we don't have a scene that needs this parameter.

Comment by Kentoku Shiba (Inactive) [ 2019-06-12 ]

It's merged to 10.4 tree. Thanks.

Generated at Thu Feb 08 07:10:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.