For the first time ever could not find a solution on internet!
The problem is when I'm trying to (on local server):
CREATE TABLE
DB_1
.testView
ENGINE=FEDERATED CONNECTION='remote_server';
I'm getting an error:
>\#1939 - Engine FEDERATED failed to discover table \DB_1\
.\testView\
with 'CREATE ALGORITHM=UNDEFINED DEFINER=\root\
@\localhost\
SQL SECURITY DEFINER VIEW \testView\
AS select 'test_line' AS \test_line\
CONNECTION='remote_server''
Obviously you can see that VIEW is very simple for testing purposes (executed on remote server):
CREATE VIEW DB_1
.testView
AS SELECT "test_line"
The user in remote_server
has all privileges. View was tested with different options and content. Federated tables work fine. Server version on both machines: 10.0.29-MariaDB-0+deb8u1
Am I missing something?
Asked by ouunp
(33 rep)
Jan 30, 2017, 10:07 AM
Last activity: Jan 30, 2017, 03:47 PM
Last activity: Jan 30, 2017, 03:47 PM