When trying to create a connect engine table with SRCDEF to a SQL Server 2016 source, it returns this error: "ERROR 1105 (HY000): Invalid Srcdef"
CREATE TABLE `Party` ENGINE=CONNECT CONNECTION='DSN=sql_server2016;uid=username;pwd=password;TDS_Version=7.4' `TABLE_TYPE`='ODBC' `TABLE_TYPE`='ODBC' `SRCDEF`='SELECT * FROM dbo.Party' `BLOCK_SIZE`=1000;
ERROR 1105 (HY000): Invalid Srcdef
I had to use `TABNAME`='Party' instead to make this work.
In a second environment I've successfully created a Connect table with a 2012 MS SQL server source with the exact same syntax above and SRCDEF above. Seems to be specific to the MS SQL Server version.