Hello everyone,

 

My name is Martijn Tonies and I’m a Windows tools developer, we have a tool called

“Database Workbench”, a developer tool for several database engines. For it’s next

major version, we’re planning to officially support MariaDB in the MySQL module.

 

I’ve investigated several of the features, implemented support for Roles, Virtual

Columns etc, but I’m having trouble with the CONNECT engine.

 

 

Here’s what I did, using MariaDB 10.0.10

 

1) registered a server with CREATE SERVER:

 

CREATE SERVER mysql55_at_local FOREIGN DATA WRAPPER mysql

  OPTIONS(HOST 'MT-XP-VM-MYSQL', PORT 3355, DATABASE 'test', USER 'root', PASSWORD ‘secret’);

 

2) created a table in the MySQL database:

CREATE TABLE sfdata (

  mark1  Integer(11),

  mark2  Integer(11),

  mark3  Integer(11),

  mark4  Integer(11),

  `name` VarChar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci

) ENGINE=InnoDB DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

 

 

3) created a table in the MariaDB database:

CREATE TABLE `sfdata_proxy3` (

  `mark1` int(11) DEFAULT NULL,

  `mark2` int(11) DEFAULT NULL,

  `mark3` int(11) DEFAULT NULL,

  `mark4` int(11) DEFAULT NULL,

  `name` varchar(50) DEFAULT NULL

) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='mysql55_at_local/sfdata'

 

 

 

I then expected that table “sfdata_proxy3” has the rows as “sfdata” has, but I got nothing returned.

 

 

Any clue where to look?

 

 

 

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!