Sample Header Ad - 728x90

Cannot create Federated View

3 votes
1 answer
1652 views
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