executor: add more cases about dynamic-mode with union/DML/subquery (#24864)
executor: add more cases about dynamic-mode with union/DML/subquery (#24864)

 
pingcap/tidb,ngaut/tidb,coocood/tidb,kyle-wang/tidb,coocood/tidb,c4pt0r/tidb,pingcap/tidb,c4pt0r/tidb,pingcap/tidb,c4pt0r/tidb,c4pt0r/tidb,kyle-wang/tidb,ngaut/tidb,ngaut/tidb,kyle-wang/tidb,pingcap/tidb,c4pt0r/tidb,kyle-wang/tidb,kyle-wang/tidb,ngaut/tidb,ngaut/tidb,pingcap/tidb,ngaut/tidb,kyle-wang/tidb,pingcap/tidb,c4pt0r/tidb