I'm attempting to set up a type 2 transform using the tMySql component. The following code is being generated, which causes errors when querying against the DB as it is invalid SQL (emphasis mine).
String updateSQLForType2_tMysqlSCD_1 = "UPDATE `"
+ "` SET `scd_end` = ? WHERE AND `scd_end` IS NULL";
This seems like a consistent issue, I've tried in a few scenarios and all generate the same faulty code. I've tried dropping out to the java layer and modifying the generated code directly, although on an in-GUI compile the faulty code is regenerated. Is there any way to get around this?