java.lang.AssertionError
	at com.alibaba.polardbx.common.charset.CharsetNameTest.testDefaultCollationMySQL57(CharsetNameTest.java:181)

java.lang.NullPointerException
	at com.alibaba.polardbx.executor.common.StorageInfoManagerTest.testDoInitWithDefaultValue(StorageInfoManagerTest.java:54)

org.junit.ComparisonFailure: expected:<ERR-CODE: [[TDDL]-12005][ERR_COLUMNAR...> but was:<ERR-CODE: [[PXC]-12005][ERR_COLUMNAR...>
	at com.alibaba.polardbx.executor.gms.ColumnarManagerTest.testPurgeWithMultiVersionSchema(ColumnarManagerTest.java:263)

java.lang.NullPointerException
	at com.alibaba.polardbx.executor.handler.LogicalShowCreateTablesForShardingDatabaseHandlerTest.showWithMySqlIndentTest(LogicalShowCreateTablesForShardingDatabaseHandlerTest.java:101)

java.lang.RuntimeException: Failed to create table
	at com.alibaba.polardbx.executor.mpp.operator.AntiJoinRFTest.<init>(AntiJoinRFTest.java:17)
Caused by: com.alibaba.polardbx.common.exception.TddlRuntimeException: ERR-CODE: [PXC-4601][ERR_EXECUTOR] Failed to create partition tables on db[optest] with mode='drds' 
	at com.alibaba.polardbx.executor.mpp.operator.AntiJoinRFTest.<init>(AntiJoinRFTest.java:17)

java.lang.RuntimeException: Failed to create table
	at com.alibaba.polardbx.executor.mpp.operator.ParallelHashJoinFactoryTest.<init>(ParallelHashJoinFactoryTest.java:14)
Caused by: com.alibaba.polardbx.common.exception.TddlRuntimeException: ERR-CODE: [PXC-4601][ERR_EXECUTOR] Failed to create partition tables on db[optest] with mode='drds' 
	at com.alibaba.polardbx.executor.mpp.operator.ParallelHashJoinFactoryTest.<init>(ParallelHashJoinFactoryTest.java:14)

java.lang.RuntimeException: Failed to create table
	at com.alibaba.polardbx.executor.mpp.operator.ParallelHashJoinFactoryTest.<init>(ParallelHashJoinFactoryTest.java:14)
Caused by: com.alibaba.polardbx.common.exception.TddlRuntimeException: ERR-CODE: [PXC-4601][ERR_EXECUTOR] Failed to create partition tables on db[optest] with mode='drds' 
	at com.alibaba.polardbx.executor.mpp.operator.ParallelHashJoinFactoryTest.<init>(ParallelHashJoinFactoryTest.java:14)

java.lang.RuntimeException: Failed to create table
	at com.alibaba.polardbx.executor.mpp.operator.ReversedAntiJoinRFTest.<init>(ReversedAntiJoinRFTest.java:21)
Caused by: com.alibaba.polardbx.common.exception.TddlRuntimeException: ERR-CODE: [PXC-4601][ERR_EXECUTOR] Failed to create partition tables on db[optest] with mode='drds' 
	at com.alibaba.polardbx.executor.mpp.operator.ReversedAntiJoinRFTest.<init>(ReversedAntiJoinRFTest.java:21)

java.lang.RuntimeException: Failed to create table
	at com.alibaba.polardbx.executor.mpp.operator.ReversedAntiJoinRFTest.<init>(ReversedAntiJoinRFTest.java:21)
Caused by: com.alibaba.polardbx.common.exception.TddlRuntimeException: ERR-CODE: [PXC-4601][ERR_EXECUTOR] Failed to create partition tables on db[optest] with mode='drds' 
	at com.alibaba.polardbx.executor.mpp.operator.ReversedAntiJoinRFTest.<init>(ReversedAntiJoinRFTest.java:21)

java.lang.NullPointerException
	at com.alibaba.polardbx.executor.partitionmanagement.rebalance.RebalanceDdlPlanManagerTest.testOnExecuting(RebalanceDdlPlanManagerTest.java:73)

java.lang.NullPointerException
	at com.alibaba.polardbx.executor.partitionmanagement.rebalance.RebalanceDdlPlanManagerTest.testOnPauseOnNonMaintenanceWindow(RebalanceDdlPlanManagerTest.java:103)

java.lang.NullPointerException
	at com.alibaba.polardbx.executor.partitionmanagement.rebalance.RebalanceDdlPlanManagerTest.testOnInit(RebalanceDdlPlanManagerTest.java:54)

java.lang.RuntimeException: Failed to create table
	at com.alibaba.polardbx.executor.statistics.SkewColumnBuildTest.<init>(SkewColumnBuildTest.java:21)
Caused by: java.lang.NullPointerException
	at com.alibaba.polardbx.executor.statistics.SkewColumnBuildTest.<init>(SkewColumnBuildTest.java:21)

org.mockito.exceptions.misusing.UnnecessaryStubbingException: 

Unnecessary stubbings detected in test class: DrdsToAutoTableCreationSqlUtilTest
Clean & maintainable test code requires zero unnecessary code.
Following stubbings are unnecessary (click to navigate to relevant line of code):
  1. -> at com.alibaba.polardbx.executor.utils.DrdsToAutoTableCreationSqlUtilTest.testGetTableNamesFromDatabase(DrdsToAutoTableCreationSqlUtilTest.java:84)
Please remove unnecessary stubbings or use 'lenient' strictness. More info: javadoc for UnnecessaryStubbingException class.

java.lang.AssertionError
	at com.alibaba.polardbx.repo.mysql.handler.LogicalBaselineHandlerTest.testBaselineDeleteBaseline(LogicalBaselineHandlerTest.java:132)

java.lang.AssertionError
	at com.alibaba.polardbx.repo.mysql.handler.LogicalBaselineHandlerTest.testBaselineAdd(LogicalBaselineHandlerTest.java:170)

java.lang.AssertionError
	at com.alibaba.polardbx.repo.mysql.handler.LogicalBaselineHandlerTest.testBaselineDeletePlan(LogicalBaselineHandlerTest.java:79)

java.lang.NullPointerException
	at com.alibaba.polardbx.optimizer.core.function.calc.scalar.encryption.AesTest.testAesEncryptAndDecrypt(AesTest.java:30)

org.apache.calcite.runtime.CalciteContextException: : Global Secondary Index 'gsi_t' already exists
	at com.alibaba.polardbx.optimizer.core.rel.PushDownReplaceTest.testPushDownReplace(PushDownReplaceTest.java:48)
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Global Secondary Index 'gsi_t' already exists
	at com.alibaba.polardbx.optimizer.core.rel.PushDownReplaceTest.testPushDownReplace(PushDownReplaceTest.java:48)

org.junit.internal.ArrayComparisonFailure: 
targetSql = 
 insert into test_hash_tb(id, name,  name) values(1, 'a', 'a');

realPlanVal = 
err-code: [pxc-4501][err_optimizer] optimize error by column 'name' specified twice.
 targetPlanVal = 
err-code: [tddl-4501][err_optimizer] optimize error by column 'name' specified twice.
: arrays first differed at element [0]; expected:<...
plan:
err-code: [[tddl]-4501][err_optimizer...> but was:<...
plan:
err-code: [[pxc]-4501][err_optimizer...>
Caused by: org.junit.ComparisonFailure: 
expected:<...
plan:
err-code: [[tddl]-4501][err_optimizer...> but was:<...
plan:
err-code: [[pxc]-4501][err_optimizer...>

org.junit.internal.ArrayComparisonFailure: 
targetSql = 
 insert into test_hash_tb(id, name,  name) values(1, 'a', 'a'), (2, 'b', 'b');

realPlanVal = 
err-code: [pxc-4501][err_optimizer] optimize error by column 'name' specified twice.
 targetPlanVal = 
err-code: [tddl-4501][err_optimizer] optimize error by column 'name' specified twice.
: arrays first differed at element [0]; expected:<...
plan:
err-code: [[tddl]-4501][err_optimizer...> but was:<...
plan:
err-code: [[pxc]-4501][err_optimizer...>
Caused by: org.junit.ComparisonFailure: 
expected:<...
plan:
err-code: [[tddl]-4501][err_optimizer...> but was:<...
plan:
err-code: [[pxc]-4501][err_optimizer...>

org.junit.internal.ArrayComparisonFailure: 
targetSql = 
 select b.name
from boy b where money = (select id from apple a where a.id = b.id and price = 12);

realPlanVal = 
gather(concurrent=true)
  logicalview(tables="[0000-0003].boy_[0-7],apple_[0-7]", shardcount=8, sql="select `name` from (select `id`, `name`, `birth_date`, `birth_place`, `money`, `height` from `boy` as `boy` where (`money` = (((select `id` from `apple` as `apple` where ((`price` = 12) and (`id` = `boy`.`id`))))))) as `t1`")
 targetPlanVal = 
gather(concurrent=true)
  logicalview(tables="[0000-0003].apple_[0-7],boy_[0-7]", shardcount=8, sql="select `name` from (select `id`, `name`, `birth_date`, `birth_place`, `money`, `height`, (((select `id` from `apple` as `apple` where ((`price` = 12) and (`id` = `boy`.`id`))))) as `id0` from `boy` as `boy`) as `t1` where (`money` = `id0`)")
: arrays first differed at element [0]; expected:<...tables="[0000-0003].[apple_[0-7],boy_[0-7]", shardcount=8, sql="select `name` from (select `id`, `name`, `birth_date`, `birth_place`, `money`, `height`, (((select `id` from `apple` as `apple` where ((`price` = 12) and (`id` = `boy`.`id`))))) as `id0` from `boy` as `boy`) as `t1` where (`money` = `id0`)]")> but was:<...tables="[0000-0003].[boy_[0-7],apple_[0-7]", shardcount=8, sql="select `name` from (select `id`, `name`, `birth_date`, `birth_place`, `money`, `height` from `boy` as `boy` where (`money` = (((select `id` from `apple` as `apple` where ((`price` = 12) and (`id` = `boy`.`id`))))))) as `t1`]")>
Caused by: org.junit.ComparisonFailure: expected:<...tables="[0000-0003].[apple_[0-7],boy_[0-7]", shardcount=8, sql="select `name` from (select `id`, `name`, `birth_date`, `birth_place`, `money`, `height`, (((select `id` from `apple` as `apple` where ((`price` = 12) and (`id` = `boy`.`id`))))) as `id0` from `boy` as `boy`) as `t1` where (`money` = `id0`)]")> but was:<...tables="[0000-0003].[boy_[0-7],apple_[0-7]", shardcount=8, sql="select `name` from (select `id`, `name`, `birth_date`, `birth_place`, `money`, `height` from `boy` as `boy` where (`money` = (((select `id` from `apple` as `apple` where ((`price` = 12) and (`id` = `boy`.`id`))))))) as `t1`]")>

org.junit.internal.ArrayComparisonFailure: 
targetSql = 
 
SELECT
    ord.*,
    orde.*
FROM
    (
        SELECT
            *
        FROM
            (
            (
                SELECT
                    *
                FROM
                    or_order oro
                LEFT JOIN
                    (
                        SELECT
                            COUNT( 1 ) butoon_Type,
                            TRANS_NO   out_trans_no
                        FROM
                            OR_OUT_STOCK
                        GROUP BY
                            out_trans_no ) oros
                ON
                    oro.TRANS_NO = oros.out_trans_no
                WHERE
                    oro.platform_code IN ( 'ELE',
                                          'MT',
                                          'BD',
                                          'JDDJ' )
                AND oro.create_time >= NOW( ) - INTERVAL 24 HOUR )
        UNION
            (
                SELECT
                    *
                FROM
                    or_order oro
                LEFT JOIN
                    (
                        SELECT
                            COUNT( 1 ) butoon_Type,
                            TRANS_NO   out_trans_no
                        FROM
                            OR_OUT_STOCK
                        GROUP BY
                            out_trans_no ) oros
                ON
                    oro.TRANS_NO = oros.out_trans_no
                WHERE
                    oro.platform_code IN ( 'ELE',
                                          'MT',
                                          'BD',
                                          'JDDJ' )
                AND oro.create_time < NOW( ) - INTERVAL 24 HOUR
                AND oro.STATUS IN ("101",
                                   "102",
                                   "103",
                                   "106",
                                   "107",
                                   "108",
                                   "401") ) ) orders
        ORDER BY
            orders.create_time DESC LIMIT 0,5 ) ord,
    or_order_item orde
WHERE
    ord.order_no = orde.order_no;

realPlanVal = 
err-code: [pxc-4006][err_table_not_exist] table 'or_order' doesn't exist.
 targetPlanVal = 
bkajoin(condition="order_no = order_no", type="inner")
  topn(sort="create_time desc", offset=0, fetch=5)
    hashagg(group="order_no,trans_no,platform_code,platform_name,shop_code,shop_name,allot_shop_code,allot_shop_name,channel_type,type,business_type,business_date,create_type,is_copy,order_time,expect_arrival_time,status,trans_status,package_fee,package_number,platform_user_id,is_fetch,o2o_dist_mode,consignee_name,consignee_telephone,salesman_mobile,salesman_type,consignee_postcode,consignee_province_code,consignee_province_name,consignee_city_code,consignee_city_name,consignee_area_code,consignee_area_name,consignee_address,express_company,logistics_no,total_amount,adjust_amount,freight_amount,discount_amount,payment_amount,payment_type,used_integral,payment_time,buyer_remark,seller_remark,is_need_invoice,invoice_type,invoice_header,invoice_content,invoice_taxer_id,product_weight,platform_commision,distributor_commision,product_volume,is_retain_order,retain_order_time,is_locked,locker,shop_income,return_flag,group_code,is_group_leader,sourcing_model,create_by,create_time,last_update_by,last_update_time,delivery_status,tip,platform_shop_code,lock_stock_type,receive_model,salesman_commision,reminder_flag,salesman_second_commision,butoon_type,out_trans_no")
      unionall(concurrent=true)
        hashjoin(condition="trans_no = out_trans_no", type="left")
          gather(concurrent=true)
            logicalview(tables="[0000-0003].or_order", shardcount=4, sql="select `order_no`, `trans_no`, `platform_code`, `platform_name`, `shop_code`, `shop_name`, `allot_shop_code`, `allot_shop_name`, `channel_type`, `type`, `business_type`, `business_date`, `create_type`, `is_copy`, `order_time`, `expect_arrival_time`, `status`, `trans_status`, `package_fee`, `package_number`, `platform_user_id`, `is_fetch`, `o2o_dist_mode`, `consignee_name`, `consignee_telephone`, `salesman_mobile`, `salesman_type`, `consignee_postcode`, `consignee_province_code`, `consignee_province_name`, `consignee_city_code`, `consignee_city_name`, `consignee_area_code`, `consignee_area_name`, `consignee_address`, `express_company`, `logistics_no`, `total_amount`, `adjust_amount`, `freight_amount`, `discount_amount`, `payment_amount`, `payment_type`, `used_integral`, `payment_time`, `buyer_remark`, `seller_remark`, `is_need_invoice`, `invoice_type`, `invoice_header`, `invoice_content`, `invoice_taxer_id`, `product_weight`, `platform_commision`, `distributor_commision`, `product_volume`, `is_retain_order`, `retain_order_time`, `is_locked`, `locker`, `shop_income`, `return_flag`, `group_code`, `is_group_leader`, `sourcing_model`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `delivery_status`, `tip`, `platform_shop_code`, `lock_stock_type`, `receive_model`, `salesman_commision`, `reminder_flag`, `salesman_second_commision` from `or_order` as `or_order` where ((`platform_code` in('ele', 'mt', 'bd', 'jddj')) and (`create_time` >= date_sub(now(), interval 24 hour)))")
          project(butoon_type="butoon_type", out_trans_no="trans_no")
            hashagg(group="trans_no", butoon_type="sum(butoon_type)")
              gather(concurrent=true)
                logicalview(tables="[0000-0003].or_out_stock", shardcount=4, sql="select `trans_no`, count(*) as `butoon_type` from `or_out_stock` as `or_out_stock` group by `trans_no`")
        hashjoin(condition="trans_no = out_trans_no", type="left")
          gather(concurrent=true)
            logicalview(tables="[0000-0003].or_order", shardcount=4, sql="select `order_no`, `trans_no`, `platform_code`, `platform_name`, `shop_code`, `shop_name`, `allot_shop_code`, `allot_shop_name`, `channel_type`, `type`, `business_type`, `business_date`, `create_type`, `is_copy`, `order_time`, `expect_arrival_time`, `status`, `trans_status`, `package_fee`, `package_number`, `platform_user_id`, `is_fetch`, `o2o_dist_mode`, `consignee_name`, `consignee_telephone`, `salesman_mobile`, `salesman_type`, `consignee_postcode`, `consignee_province_code`, `consignee_province_name`, `consignee_city_code`, `consignee_city_name`, `consignee_area_code`, `consignee_area_name`, `consignee_address`, `express_company`, `logistics_no`, `total_amount`, `adjust_amount`, `freight_amount`, `discount_amount`, `payment_amount`, `payment_type`, `used_integral`, `payment_time`, `buyer_remark`, `seller_remark`, `is_need_invoice`, `invoice_type`, `invoice_header`, `invoice_content`, `invoice_taxer_id`, `product_weight`, `platform_commision`, `distributor_commision`, `product_volume`, `is_retain_order`, `retain_order_time`, `is_locked`, `locker`, `shop_income`, `return_flag`, `group_code`, `is_group_leader`, `sourcing_model`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `delivery_status`, `tip`, `platform_shop_code`, `lock_stock_type`, `receive_model`, `salesman_commision`, `reminder_flag`, `salesman_second_commision` from `or_order` as `or_order` where ((`platform_code` in('ele', 'mt', 'bd', 'jddj')) and (`status` in('101', '102', '103', '106', '107', '108', '401')) and (`create_time` < date_sub(now(), interval 24 hour)))")
          project(butoon_type="butoon_type", out_trans_no="trans_no")
            hashagg(group="trans_no", butoon_type="sum(butoon_type)")
              gather(concurrent=true)
                logicalview(tables="[0000-0003].or_out_stock", shardcount=4, sql="select `trans_no`, count(*) as `butoon_type` from `or_out_stock` as `or_out_stock` group by `trans_no`")
  gather(concurrent=true)
    logicalview(tables="[0000-0003].or_order_item", shardcount=4, sql="select `id`, `order_no`, `sub_order_no`, `bag_code`, `product_code`, `product_name`, `one_category_code`, `one_category_name`, `two_category_code`, `two_category_name`, `three_category_code`, `three_category_name`, `product_brand_code`, `product_brand_name`, `product_barcode`, `product_sku`, `product_price`, `product_spec`, `platform_product_sku`, `product_meter_unit`, `platform_product_code`, `platform_product_name`, `platform_product_url`, `buy_number`, `out_stock_number`, `product_weight`, `product_volume`, `discount_amount`, `share_amount`, `payable_amount`, `coupon_duct_amount`, `paid_amount`, `is_split`, `group_product_code`, `group_product_name`, `integral_share`, `is_out_stock`, `is_gift`, `activity_name`, `activity_id`, `platform_commision_point`, `platform_commision`, `distributor_commision`, `salesman_commision`, `return_type`, `factory_cost`, `is_cancel`, `erp_order_item_id`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `platform_product_index`, `salesman_second_commision` from `or_order_item` as `or_order_item` force index(`auto_shard_key_order_no`) where (`order_no` in (...))")
: arrays first differed at element [0]; expected:<....order_no;

plan:
[bkajoin(condition="order_no = order_no", type="inner")
  topn(sort="create_time desc", offset=0, fetch=5)
    hashagg(group="order_no,trans_no,platform_code,platform_name,shop_code,shop_name,allot_shop_code,allot_shop_name,channel_type,type,business_type,business_date,create_type,is_copy,order_time,expect_arrival_time,status,trans_status,package_fee,package_number,platform_user_id,is_fetch,o2o_dist_mode,consignee_name,consignee_telephone,salesman_mobile,salesman_type,consignee_postcode,consignee_province_code,consignee_province_name,consignee_city_code,consignee_city_name,consignee_area_code,consignee_area_name,consignee_address,express_company,logistics_no,total_amount,adjust_amount,freight_amount,discount_amount,payment_amount,payment_type,used_integral,payment_time,buyer_remark,seller_remark,is_need_invoice,invoice_type,invoice_header,invoice_content,invoice_taxer_id,product_weight,platform_commision,distributor_commision,product_volume,is_retain_order,retain_order_time,is_locked,locker,shop_income,return_flag,group_code,is_group_leader,sourcing_model,create_by,create_time,last_update_by,last_update_time,delivery_status,tip,platform_shop_code,lock_stock_type,receive_model,salesman_commision,reminder_flag,salesman_second_commision,butoon_type,out_trans_no")
      unionall(concurrent=true)
        hashjoin(condition="trans_no = out_trans_no", type="left")
          gather(concurrent=true)
            logicalview(tables="[0000-0003].or_order", shardcount=4, sql="select `order_no`, `trans_no`, `platform_code`, `platform_name`, `shop_code`, `shop_name`, `allot_shop_code`, `allot_shop_name`, `channel_type`, `type`, `business_type`, `business_date`, `create_type`, `is_copy`, `order_time`, `expect_arrival_time`, `status`, `trans_status`, `package_fee`, `package_number`, `platform_user_id`, `is_fetch`, `o2o_dist_mode`, `consignee_name`, `consignee_telephone`, `salesman_mobile`, `salesman_type`, `consignee_postcode`, `consignee_province_code`, `consignee_province_name`, `consignee_city_code`, `consignee_city_name`, `consignee_area_code`, `consignee_area_name`, `consignee_address`, `express_company`, `logistics_no`, `total_amount`, `adjust_amount`, `freight_amount`, `discount_amount`, `payment_amount`, `payment_type`, `used_integral`, `payment_time`, `buyer_remark`, `seller_remark`, `is_need_invoice`, `invoice_type`, `invoice_header`, `invoice_content`, `invoice_taxer_id`, `product_weight`, `platform_commision`, `distributor_commision`, `product_volume`, `is_retain_order`, `retain_order_time`, `is_locked`, `locker`, `shop_income`, `return_flag`, `group_code`, `is_group_leader`, `sourcing_model`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `delivery_status`, `tip`, `platform_shop_code`, `lock_stock_type`, `receive_model`, `salesman_commision`, `reminder_flag`, `salesman_second_commision` from `or_order` as `or_order` where ((`platform_code` in('ele', 'mt', 'bd', 'jddj')) and (`create_time` >= date_sub(now(), interval 24 hour)))")
          project(butoon_type="butoon_type", out_trans_no="trans_no")
            hashagg(group="trans_no", butoon_type="sum(butoon_type)")
              gather(concurrent=true)
                logicalview(tables="[0000-0003].or_out_stock", shardcount=4, sql="select `trans_no`, count(*) as `butoon_type` from `or_out_stock` as `or_out_stock` group by `trans_no`")
        hashjoin(condition="trans_no = out_trans_no", type="left")
          gather(concurrent=true)
            logicalview(tables="[0000-0003].or_order", shardcount=4, sql="select `order_no`, `trans_no`, `platform_code`, `platform_name`, `shop_code`, `shop_name`, `allot_shop_code`, `allot_shop_name`, `channel_type`, `type`, `business_type`, `business_date`, `create_type`, `is_copy`, `order_time`, `expect_arrival_time`, `status`, `trans_status`, `package_fee`, `package_number`, `platform_user_id`, `is_fetch`, `o2o_dist_mode`, `consignee_name`, `consignee_telephone`, `salesman_mobile`, `salesman_type`, `consignee_postcode`, `consignee_province_code`, `consignee_province_name`, `consignee_city_code`, `consignee_city_name`, `consignee_area_code`, `consignee_area_name`, `consignee_address`, `express_company`, `logistics_no`, `total_amount`, `adjust_amount`, `freight_amount`, `discount_amount`, `payment_amount`, `payment_type`, `used_integral`, `payment_time`, `buyer_remark`, `seller_remark`, `is_need_invoice`, `invoice_type`, `invoice_header`, `invoice_content`, `invoice_taxer_id`, `product_weight`, `platform_commision`, `distributor_commision`, `product_volume`, `is_retain_order`, `retain_order_time`, `is_locked`, `locker`, `shop_income`, `return_flag`, `group_code`, `is_group_leader`, `sourcing_model`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `delivery_status`, `tip`, `platform_shop_code`, `lock_stock_type`, `receive_model`, `salesman_commision`, `reminder_flag`, `salesman_second_commision` from `or_order` as `or_order` where ((`platform_code` in('ele', 'mt', 'bd', 'jddj')) and (`status` in('101', '102', '103', '106', '107', '108', '401')) and (`create_time` < date_sub(now(), interval 24 hour)))")
          project(butoon_type="butoon_type", out_trans_no="trans_no")
            hashagg(group="trans_no", butoon_type="sum(butoon_type)")
              gather(concurrent=true)
                logicalview(tables="[0000-0003].or_out_stock", shardcount=4, sql="select `trans_no`, count(*) as `butoon_type` from `or_out_stock` as `or_out_stock` group by `trans_no`")
  gather(concurrent=true)
    logicalview(tables="[0000-0003].or_order_item", shardcount=4, sql="select `id`, `order_no`, `sub_order_no`, `bag_code`, `product_code`, `product_name`, `one_category_code`, `one_category_name`, `two_category_code`, `two_category_name`, `three_category_code`, `three_category_name`, `product_brand_code`, `product_brand_name`, `product_barcode`, `product_sku`, `product_price`, `product_spec`, `platform_product_sku`, `product_meter_unit`, `platform_product_code`, `platform_product_name`, `platform_product_url`, `buy_number`, `out_stock_number`, `product_weight`, `product_volume`, `discount_amount`, `share_amount`, `payable_amount`, `coupon_duct_amount`, `paid_amount`, `is_split`, `group_product_code`, `group_product_name`, `integral_share`, `is_out_stock`, `is_gift`, `activity_name`, `activity_id`, `platform_commision_point`, `platform_commision`, `distributor_commision`, `salesman_commision`, `return_type`, `factory_cost`, `is_cancel`, `erp_order_item_id`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `platform_product_index`, `salesman_second_commision` from `or_order_item` as `or_order_item` force index(`auto_shard_key_order_no`) where (`order_no` in (...))")]> but was:<....order_no;

plan:
[err-code: [pxc-4006][err_table_not_exist] table 'or_order' doesn't exist.]>
Caused by: org.junit.ComparisonFailure: 
expected:<....order_no;

plan:
[bkajoin(condition="order_no = order_no", type="inner")
  topn(sort="create_time desc", offset=0, fetch=5)
    hashagg(group="order_no,trans_no,platform_code,platform_name,shop_code,shop_name,allot_shop_code,allot_shop_name,channel_type,type,business_type,business_date,create_type,is_copy,order_time,expect_arrival_time,status,trans_status,package_fee,package_number,platform_user_id,is_fetch,o2o_dist_mode,consignee_name,consignee_telephone,salesman_mobile,salesman_type,consignee_postcode,consignee_province_code,consignee_province_name,consignee_city_code,consignee_city_name,consignee_area_code,consignee_area_name,consignee_address,express_company,logistics_no,total_amount,adjust_amount,freight_amount,discount_amount,payment_amount,payment_type,used_integral,payment_time,buyer_remark,seller_remark,is_need_invoice,invoice_type,invoice_header,invoice_content,invoice_taxer_id,product_weight,platform_commision,distributor_commision,product_volume,is_retain_order,retain_order_time,is_locked,locker,shop_income,return_flag,group_code,is_group_leader,sourcing_model,create_by,create_time,last_update_by,last_update_time,delivery_status,tip,platform_shop_code,lock_stock_type,receive_model,salesman_commision,reminder_flag,salesman_second_commision,butoon_type,out_trans_no")
      unionall(concurrent=true)
        hashjoin(condition="trans_no = out_trans_no", type="left")
          gather(concurrent=true)
            logicalview(tables="[0000-0003].or_order", shardcount=4, sql="select `order_no`, `trans_no`, `platform_code`, `platform_name`, `shop_code`, `shop_name`, `allot_shop_code`, `allot_shop_name`, `channel_type`, `type`, `business_type`, `business_date`, `create_type`, `is_copy`, `order_time`, `expect_arrival_time`, `status`, `trans_status`, `package_fee`, `package_number`, `platform_user_id`, `is_fetch`, `o2o_dist_mode`, `consignee_name`, `consignee_telephone`, `salesman_mobile`, `salesman_type`, `consignee_postcode`, `consignee_province_code`, `consignee_province_name`, `consignee_city_code`, `consignee_city_name`, `consignee_area_code`, `consignee_area_name`, `consignee_address`, `express_company`, `logistics_no`, `total_amount`, `adjust_amount`, `freight_amount`, `discount_amount`, `payment_amount`, `payment_type`, `used_integral`, `payment_time`, `buyer_remark`, `seller_remark`, `is_need_invoice`, `invoice_type`, `invoice_header`, `invoice_content`, `invoice_taxer_id`, `product_weight`, `platform_commision`, `distributor_commision`, `product_volume`, `is_retain_order`, `retain_order_time`, `is_locked`, `locker`, `shop_income`, `return_flag`, `group_code`, `is_group_leader`, `sourcing_model`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `delivery_status`, `tip`, `platform_shop_code`, `lock_stock_type`, `receive_model`, `salesman_commision`, `reminder_flag`, `salesman_second_commision` from `or_order` as `or_order` where ((`platform_code` in('ele', 'mt', 'bd', 'jddj')) and (`create_time` >= date_sub(now(), interval 24 hour)))")
          project(butoon_type="butoon_type", out_trans_no="trans_no")
            hashagg(group="trans_no", butoon_type="sum(butoon_type)")
              gather(concurrent=true)
                logicalview(tables="[0000-0003].or_out_stock", shardcount=4, sql="select `trans_no`, count(*) as `butoon_type` from `or_out_stock` as `or_out_stock` group by `trans_no`")
        hashjoin(condition="trans_no = out_trans_no", type="left")
          gather(concurrent=true)
            logicalview(tables="[0000-0003].or_order", shardcount=4, sql="select `order_no`, `trans_no`, `platform_code`, `platform_name`, `shop_code`, `shop_name`, `allot_shop_code`, `allot_shop_name`, `channel_type`, `type`, `business_type`, `business_date`, `create_type`, `is_copy`, `order_time`, `expect_arrival_time`, `status`, `trans_status`, `package_fee`, `package_number`, `platform_user_id`, `is_fetch`, `o2o_dist_mode`, `consignee_name`, `consignee_telephone`, `salesman_mobile`, `salesman_type`, `consignee_postcode`, `consignee_province_code`, `consignee_province_name`, `consignee_city_code`, `consignee_city_name`, `consignee_area_code`, `consignee_area_name`, `consignee_address`, `express_company`, `logistics_no`, `total_amount`, `adjust_amount`, `freight_amount`, `discount_amount`, `payment_amount`, `payment_type`, `used_integral`, `payment_time`, `buyer_remark`, `seller_remark`, `is_need_invoice`, `invoice_type`, `invoice_header`, `invoice_content`, `invoice_taxer_id`, `product_weight`, `platform_commision`, `distributor_commision`, `product_volume`, `is_retain_order`, `retain_order_time`, `is_locked`, `locker`, `shop_income`, `return_flag`, `group_code`, `is_group_leader`, `sourcing_model`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `delivery_status`, `tip`, `platform_shop_code`, `lock_stock_type`, `receive_model`, `salesman_commision`, `reminder_flag`, `salesman_second_commision` from `or_order` as `or_order` where ((`platform_code` in('ele', 'mt', 'bd', 'jddj')) and (`status` in('101', '102', '103', '106', '107', '108', '401')) and (`create_time` < date_sub(now(), interval 24 hour)))")
          project(butoon_type="butoon_type", out_trans_no="trans_no")
            hashagg(group="trans_no", butoon_type="sum(butoon_type)")
              gather(concurrent=true)
                logicalview(tables="[0000-0003].or_out_stock", shardcount=4, sql="select `trans_no`, count(*) as `butoon_type` from `or_out_stock` as `or_out_stock` group by `trans_no`")
  gather(concurrent=true)
    logicalview(tables="[0000-0003].or_order_item", shardcount=4, sql="select `id`, `order_no`, `sub_order_no`, `bag_code`, `product_code`, `product_name`, `one_category_code`, `one_category_name`, `two_category_code`, `two_category_name`, `three_category_code`, `three_category_name`, `product_brand_code`, `product_brand_name`, `product_barcode`, `product_sku`, `product_price`, `product_spec`, `platform_product_sku`, `product_meter_unit`, `platform_product_code`, `platform_product_name`, `platform_product_url`, `buy_number`, `out_stock_number`, `product_weight`, `product_volume`, `discount_amount`, `share_amount`, `payable_amount`, `coupon_duct_amount`, `paid_amount`, `is_split`, `group_product_code`, `group_product_name`, `integral_share`, `is_out_stock`, `is_gift`, `activity_name`, `activity_id`, `platform_commision_point`, `platform_commision`, `distributor_commision`, `salesman_commision`, `return_type`, `factory_cost`, `is_cancel`, `erp_order_item_id`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `platform_product_index`, `salesman_second_commision` from `or_order_item` as `or_order_item` force index(`auto_shard_key_order_no`) where (`order_no` in (...))")]> but was:<....order_no;

plan:
[err-code: [pxc-4006][err_table_not_exist] table 'or_order' doesn't exist.]>

com.alibaba.polardbx.common.exception.NotSupportException: ERR-CODE: [PXC-4998][ERR_NOT_SUPPORT] xproto required not support yet! 
	at com.alibaba.polardbx.cdc.MetaBuilderTest.testGetPhyConnection(MetaBuilderTest.java:38)

com.alibaba.polardbx.common.exception.NotSupportException: ERR-CODE: [PXC-4998][ERR_NOT_SUPPORT] xproto required not support yet! 
	at com.alibaba.polardbx.cdc.MetaBuilderTest.testPreparePhyConnection(MetaBuilderTest.java:50)