...
It is important to note that we have observed the following changes in behavior with the new MySQL JDBC Connector:
Change 1
If the SQL Task Instance or Stored Procedure Task Instance is currently processing the SLEEP
(\n) function at the time a cancel is attempted, depending on the SQL statement, a MySQLStatementCancelledException may no longer be thrown, meaning the SQL Task Instance or Stored Procedure Task Instance will immediately transition to Success from Cancel Pending, rather than transitioning to Cancelled.
...
For more information on the SLEEP function, please see the MySQL documentation here: https://dev.mysql.com/doc/refman/5.6/en/miscellaneous-functions.html#function_sleep
Change 2
If the server time zone value is unrecognized or represents more than one time zone, you must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specific time zone value if you want to utilize time zone support.
...