Mac OS X Mavericks

In all PROXY based tables, you can specify the connection parameters (as for MYSQL tables)
For instance, the default host is 'localhost' but can be changed to an IP address. You can alternatively use an URL or even give the name of a pre-defined connection server.
Perhaps this enables you to solve your probem.

Olivier, yeah, adding "host" fixes it for the bind-address issue, but if you ever try binding mysqld to another interface or the IP address changes or something, all of your CONNECT/MYSQL tables will stop working! Maybe just something to document somewhere.

And I think you can't work around the skip-networking issue unless CONNECT gets support for socket file connections.

I presume these problems also occur with FEDERATED. Did you try it? If they have a solution, I 'll look at it.

It seems only logical that Federated has a similar problem, but that is only logical since for every Federated table you must specify some remote name. Many Connect table types rely on implicit "localhost" tables and it's quite confusing in the first place for that to involve TCP. In other words, Federated tables pointing back to the same server must be much less common than Connect tables pointing to the same server.

Here is what I have done and pushed:

• On Linux, connection specifying "localhost" (the default) will now use Unix socket.
• On Windows, the default for local connection is to use shared memory. However, not all servers enable this and then TCP is used by default. What can be done then is to specify the host as "." and the connection will use named pipe.

Kolbe, can you test that this works in all cases so I can close this issue? Thanks.

When creating a proxy based table, CONNECT can test if the table point on itself. However, testing pointing back to the same table when several tables are chained cannot be done if one of the table in the chain is not a CONNECT table.

I can try to test this, but not right away. I have been building MariaDB 10 on OS X, I will need to set up a Linux build environment. I won't attempt to build or test on Windows.

I did test on Windows. On Linux, I just test on ubuntu with --skip-networking.
Maybe that's enough.

Here is what is done now for the MYSQL and PROXY (via MySQL) table types:
When the host is specified as “localhost”, the connection is established on Linux using Linux socket.
On Windows, the connection is established by default using share memory if it is enabled. If not the TCP protocol is used. An alternative is to specify the host as “.” to use a named pipe connection (if it is enabled)
This makes possible to use these table types with server skipping networking.