I've found a problem with connect engine using SRCDEF notation when creating a table. The problem is a broken table created when SRCDEF parameter contains an sql query more than 32 kb long. For example, sql query with long list of ids in "where x IN ( ... )" conditional statement.
The following error appears on create table: "Engine CONNECT failed to discover table `db`.`connect_1` with 'CREATE TABLE whatever .... skip
The table can't be dropped due to the error: "Incorrect information in file './db/connect_1.frm'".
The desired behaviour is to get the ability to use long queries in SRCDEF parameter with the length limited by some configuration parameter.