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)

expected:<ERR-CODE: [[TDDL]-12005][ERR_COLUMNAR...> but was:<ERR-CODE: [[PXC]-12005][ERR_COLUMNAR...>

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

Failed to create table

Failed to create table

Failed to create table

Failed to create table

Failed to create table

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)

Failed to create table

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)

: Global Secondary Index 'gsi_t' already exists

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...>

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...>

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`]")>

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.]>

ERR-CODE: [PXC-4998][ERR_NOT_SUPPORT] xproto required not support yet!

ERR-CODE: [PXC-4998][ERR_NOT_SUPPORT] xproto required not support yet!

expected:<PolarDB V2_2.[5.0]_5.4.20-20241015_8.4...> but was:<PolarDB V2_2.[4.1]_5.4.20-20241015_8.4...>

There were 26 failed tests

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v1, stCarolas/[email protected]. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/