environment

• canal version 1.1.7-SNAPSHOT-alpha3
• mysql version 8.0.28

Issue Description

mysql存储过程中的这种语句
mysql> CREATE TABLE test (a INT NOT NULL AUTO_INCREMENT,
-> PRIMARY KEY (a), KEY(b))
-> ENGINE=InnoDB SELECT b,c FROM test2;

在adapter日志中正常解析一个DDL之后报如下错误
java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'START TRANSACTION' at line 73

分开该语句create + insert就不会