`create procedure` is not recognized as `ExpandSyntax`

See isExpandSyntaxQuery(), regexCreateProcedure

[asiroliu]

增加了不配置ExpandSyntax就不应复制procedure、function的自动化测试用例

[asiroliu]

已确认create FUNCTION/PROCEDURE处理正确， 但是alert FUNCTION/PROCEDURE被复制到了目标端，drop暂时无法验证，也请一并排查一下

version:
9.9.9.9-master-1e50c92

预置条件,目标端账户有足够权限：

GRANT CREATE ROUTINE, SUPER ON *.* TO 'test_dest'@'%';

1. 设置expand_syntax_support=false
2. 源端MySQL执行如下SQL:

mysql> CREATE TABLE t1 (id INT(11) AUTO_INCREMENT PRIMARY KEY, score INT(11));
mysql> INSERT t1 VALUES (NULL, 99); 
mysql> INSERT t1 VALUES (NULL, 62);
mysql> INSERT t1 VALUES (NULL, 83);
mysql> CREATE FUNCTION f3() RETURNS DECIMAL(10,2) READS SQL DATA BEGIN DECLARE avg_score DECIMAL(10,2) DEFAULT 0; SELECT AVG(score) INTO avg_score FROM t1; return avg_score; END
mysql> ALTER FUNCTION f3 SQL SECURITY DEFINER;

3. 检查目标端 general log, ALTER FUNCTION传输到了目标端

2022-03-29T06:14:39.044423Z       137 Query     START TRANSACTION
2022-03-29T06:14:39.044649Z       137 Query     USE `action_db_1`
2022-03-29T06:14:39.045120Z       137 Query     ALTER FUNCTION f3 SQL SECURITY DEFINER /*dtle_gtid1 ddl_function_expand_syntax_support_false-migration 576778b8-af27-11ec-bc36-0242ac640903 25 dtle_gtid*/
2022-03-29T06:14:39.045546Z       167 Quit
2022-03-29T06:14:39.045596Z       166 Quit
2022-03-29T06:14:39.045610Z       137 Query     ROLLBACK

4. 源端MySQL执行如下SQL:

mysql> CREATE PROCEDURE p1() READS SQL DATA BEGIN DECLARE avg_score DECIMAL(10,2) DEFAULT 0; SELECT AVG(score) INTO avg_score FROM t1; END
mysql> ALTER PROCEDURE p3 SQL SECURITY DEFINER;

5. 检查目标端 general log, ALTER PROCEDURE传输到了目标端

2022-03-29T06:10:59.940081Z       135 Query     START TRANSACTION
2022-03-29T06:10:59.940475Z       135 Query     USE `action_db_1`
2022-03-29T06:10:59.941090Z       135 Query     ALTER PROCEDURE p3 SQL SECURITY DEFINER /*dtle_gtid1 ddl_procedure_expand_syntax_support_false-migration d53c6bf9-af26-11ec-aa0e-0242ac640902 25 dtle_gtid*/
2022-03-29T06:10:59.942121Z       165 Quit
2022-03-29T06:10:59.942175Z       135 Query     ROLLBACK