Comments - Data limit on joins with connect tables?

7 years ago Tobias Post

SELECT * FROM innodb_table LEFT JOIN connect_table ON innodb_table.attrib = connect_table.attrib;

... gives the same problems.

This join can not be build on the external server because innodb_table is local and only connect_table's source is external.

[Tested with MariaDB v10.0.9 & v10.0.10 (both 64-bit) and ODBC drivers Informix v3.70.FC8 & v4.10.FC3 and MySQL Connector/ODBC v5.2.6 (all three 64-bit) on Windows 7 Enterprise SP1 (64-bit).]

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.