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

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

ERR-CODE: [PXC-9001][ERR_GMS_GENERIC] acquire meta db error.

ERR-CODE: [PXC-9001][ERR_GMS_GENERIC] acquire meta db error.

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

: Global Secondary Index 'gsi_t' already exists

targetSql = SELECT foo.id AS foo_id, foo.bar AS foo_bar, foo.`range` AS foo_range FROM alchemy_foo as foo ORDER BY foo.bar LIMIT -1, 18446744073709551615; realPlanVal = err-code: [pxc-4501][err_optimizer] optimize error by get rex -1 targetPlanVal = err-code: [tddl-4501][err_optimizer] optimize error by get rex -1 : 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 foo.id AS foo_id, foo.bar AS foo_bar, foo.`range` AS foo_range FROM alchemy_foo as foo ORDER BY foo.bar LIMIT 18446744073709551615, -1; realPlanVal = err-code: [pxc-4501][err_optimizer] optimize error by get rex -1 targetPlanVal = err-code: [tddl-4501][err_optimizer] optimize error by get rex -1 : 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 foo.id AS foo_id, foo.bar AS foo_bar, foo.`range` AS foo_range FROM alchemy_foo as foo ORDER BY foo.bar LIMIT -1, 10; realPlanVal = err-code: [pxc-4501][err_optimizer] optimize error by get rex -1 targetPlanVal = err-code: [tddl-4501][err_optimizer] optimize error by get rex -1 : 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 foo.id AS foo_id, foo.bar AS foo_bar, foo.`range` AS foo_range FROM alchemy_foo as foo ORDER BY foo.bar LIMIT 10, -1; realPlanVal = err-code: [pxc-4501][err_optimizer] optimize error by get rex -1 targetPlanVal = err-code: [tddl-4501][err_optimizer] optimize error by get rex -1 : 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 foo.id AS foo_id, foo.bar AS foo_bar, foo.`range` AS foo_range FROM alchemy_foo as foo ORDER BY foo.bar LIMIT 10, -11; realPlanVal = err-code: [pxc-4501][err_optimizer] optimize error by get rex -11 targetPlanVal = err-code: [tddl-4501][err_optimizer] optimize error by get rex -11 : 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 foo.id AS foo_id, foo.bar AS foo_bar, foo.`range` AS foo_range FROM alchemy_foo as foo ORDER BY foo.bar LIMIT 10, -18446744073709551615; realPlanVal = err-code: [pxc-4501][err_optimizer] optimize error by get rex -18446744073709551615 targetPlanVal = err-code: [tddl-4501][err_optimizer] optimize error by get rex -18446744073709551615 : 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'); 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 l_partkey, now(),sysdate(),curdate(),curtime(),utc_date(), utc_time(), utc_timestamp(), date('2008-09-10 07:15:30.123456'), time('2008-09-10 07:15:30.123456'), year('2008-09-10 07:15:30.123456'), quarter('2008-09-10 07:15:30.123456'), month('2008-09-10 07:15:30.123456'), week('2008-09-10 07:15:30.123456'), day('2008-09-10 07:15:30.123456'), hour('2008-09-10 07:15:30.123456'), minute('2008-09-10 07:15:30.123456'), second('2008-09-10 07:15:30.123456'), microsecond('2008-09-10 07:15:30.123456'), dayofweek('2008-09-10 07:15:30.123456'), dayofyear('2008-09-10 07:15:30.123456'), weekofyear('2008-09-10 07:15:30.123456'), weekday('2008-09-10 07:15:30.123456'), yearweek('2008-09-10 07:15:30.123456'), dayname('2008-09-10 07:15:30.123456'), monthname('2008-09-10 07:15:30.123456'), last_day('2008-09-10 07:15:30.123456'), date_add('2008-09-10 07:15:30.123456', interval 1 minute), date_sub('2008-09-10 07:15:30.123456',interval '1 1:1:1' day_second), timediff('2008-09-10 07:15:30.123456','2008-09-09 07:15:30.123456'), datediff('2008-09-10 07:15:30.123456','2008-09-09 07:15:30.123456'), to_days('2008-09-10 07:15:30.123456'), from_days(733627), 1+2 +(CAST( -11 AS DECIMAL)) from lineitem; realPlanVal = com.alibaba.polardbx.optimizer.core.datatype.intervaltype cannot be cast to java.lang.number targetPlanVal = project(l_partkey="l_partkey", now()="now()", sysdate()="sysdate()", curdate()="curdate()", curtime()="curtime()", utc_date()="utc_date()", utc_time()="utc_time()", utc_timestamp()="utc_timestamp()", date('2008-09-10 07:15:30.123456')="date('2008-09-10 07:15:30.123456')", time('2008-09-10 07:15:30.123456')="time('2008-09-10 07:15:30.123456')", year('2008-09-10 07:15:30.123456')="2008", quarter('2008-09-10 07:15:30.123456')="3", month('2008-09-10 07:15:30.123456')="9", week('2008-09-10 07:15:30.123456')="36", day('2008-09-10 07:15:30.123456')="10", hour('2008-09-10 07:15:30.123456')="7", minute('2008-09-10 07:15:30.123456')="15", second('2008-09-10 07:15:30.123456')="30", microsecond('2008-09-10 07:15:30.123456')="123456", dayofweek('2008-09-10 07:15:30.123456')="4", dayofyear('2008-09-10 07:15:30.123456')="254", weekofyear('2008-09-10 07:15:30.123456')="37", weekday('2008-09-10 07:15:30.123456')="2", yearweek('2008-09-10 07:15:30.123456')="200836", dayname('2008-09-10 07:15:30.123456')="dayname('2008-09-10 07:15:30.123456')", monthname('2008-09-10 07:15:30.123456')="monthname('2008-09-10 07:15:30.123456')", last_day('2008-09-10 07:15:30.123456')="last_day('2008-09-10 07:15:30.123456')", date_add('2008-09-10 07:15:30.123456', interval 1 minute)="date_add('2008-09-10 07:15:30.123456', interval_primary(1, minute))", date_sub('2008-09-10 07:15:30.123456', interval '1 1:1:1' day_second)="date_sub('2008-09-10 07:15:30.123456', interval_primary('1 1:1:1', day_second))", timediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')="timediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')", datediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')="1", to_days('2008-09-10 07:15:30.123456')="733660", from_days(733627)="from_days(733627)", 1 + 2 + cast(-11 as decimal)="3 + cast(-11)") logicalview(tables="[0000-0003].lineitem_[00-15]", shardcount=16, sql="select `l_orderkey`, `l_partkey`, `l_suppkey`, `l_linenumber`, `l_quantity`, `l_extendedprice`, `l_discount`, `l_tax`, `l_returnflag`, `l_linestatus`, `l_shipdate`, `l_commitdate`, `l_receiptdate`, `l_shipinstruct`, `l_shipmode`, `l_comment` from `lineitem` as `lineitem`") : arrays first differed at element [0]; expected:<... lineitem; plan: [project(l_partkey="l_partkey", now()="now()", sysdate()="sysdate()", curdate()="curdate()", curtime()="curtime()", utc_date()="utc_date()", utc_time()="utc_time()", utc_timestamp()="utc_timestamp()", date('2008-09-10 07:15:30.123456')="date('2008-09-10 07:15:30.123456')", time('2008-09-10 07:15:30.123456')="time('2008-09-10 07:15:30.123456')", year('2008-09-10 07:15:30.123456')="2008", quarter('2008-09-10 07:15:30.123456')="3", month('2008-09-10 07:15:30.123456')="9", week('2008-09-10 07:15:30.123456')="36", day('2008-09-10 07:15:30.123456')="10", hour('2008-09-10 07:15:30.123456')="7", minute('2008-09-10 07:15:30.123456')="15", second('2008-09-10 07:15:30.123456')="30", microsecond('2008-09-10 07:15:30.123456')="123456", dayofweek('2008-09-10 07:15:30.123456')="4", dayofyear('2008-09-10 07:15:30.123456')="254", weekofyear('2008-09-10 07:15:30.123456')="37", weekday('2008-09-10 07:15:30.123456')="2", yearweek('2008-09-10 07:15:30.123456')="200836", dayname('2008-09-10 07:15:30.123456')="dayname('2008-09-10 07:15:30.123456')", monthname('2008-09-10 07:15:30.123456')="monthname('2008-09-10 07:15:30.123456')", last_day('2008-09-10 07:15:30.123456')="last_day('2008-09-10 07:15:30.123456')", date_add('2008-09-10 07:15:30.123456', interval 1 minute)="date_add('2008-09-10 07:15:30.123456', interval_primary(1, minute))", date_sub('2008-09-10 07:15:30.123456', interval '1 1:1:1' day_second)="date_sub('2008-09-10 07:15:30.123456', interval_primary('1 1:1:1', day_second))", timediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')="timediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')", datediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')="1", to_days('2008-09-10 07:15:30.123456')="733660", from_days(733627)="from_days(733627)", 1 + 2 + cast(-11 as decimal)="3 + cast(-11)") logicalview(tables="[0000-0003].lineitem_[00-15]", shardcount=16, sql="select `l_orderkey`, `l_partkey`, `l_suppkey`, `l_linenumber`, `l_quantity`, `l_extendedprice`, `l_discount`, `l_tax`, `l_returnflag`, `l_linestatus`, `l_shipdate`, `l_commitdate`, `l_receiptdate`, `l_shipinstruct`, `l_shipmode`, `l_comment` from `lineitem` as `lineitem`")]> but was:<... lineitem; plan: [com.alibaba.polardbx.optimizer.core.datatype.intervaltype cannot be cast to java.lang.number]>

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` 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` where (`order_no` in (...))")]> but was:<....order_no; plan: [err-code: [pxc-4006][err_table_not_exist] table 'or_order' doesn't exist.]>

There were 24 failed tests

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