Aggregation: multiple MySQL tables are merged into a single MySQL+DDL - which does not support partition types : alter xx drop 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 2f5d3002cda0f5b4731538d881311e74e8ec9691)

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.

"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_drop_partition drop partition p0;

Actual results:

1. job will be shut down

"Below is screenshot:"

[yaqigithub]

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