Aggregation: multiple MySQL tables are merged into a single MySQL+DDL - which does not support partition types : alter xx add xx partition xx

[actiontech-bot]

Problem Description:
when execute the statement of 'alter xx drop xx partition xx' on the two source database at the same time, the job will be 'shut down'.

Version: (git: master 2f5d300)

Prepare Test Environment:
Prepare 3 mysql instances on different hosts.(for example:10.196.30.94 ,10.186.30.90, 10.186.30.7 )

Dtle deploy:
+---------------------------------------------------------------------+
host        |   dtle(manager/agent) |   mysql                        |
10.186.30.94|  manager/agent       |  mysql source-database-one      |
10.186.30.90|  agent               |  mysql source-database-two      |
10.186.30.7 |  agent               |  mysql target-database          |
+---------------------------------------------------------------------+

Steps To Reproduce:
Step 1: create two repository level's jobs on Dtle to merge two source database's data to target database's table.
For example:

"ReplicateDoDb": [
                 {
                    "TableSchema": "bjaction002",
                    "Tables": []
                }
            ],

Step 2: execute the below statement on two source databases at same time:

create table t_drop_partition (id int , year_col int) partition by range (year_col) (
    partition p0 values less than (1991),
    partition p1 values less than (1995),
    partition p2 values less than (1999)
);
alter table t_add_partition add partition (partition p3 values less than (2002));

Actual results:

job will be shut down

[yaqigithub]

job still be shut down (version Dtle 9.9.9.9 (git: master 203100a))