net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" #2024
Description
the JsQlParser version is 4.6 and this sql like below:
`SELECT
`id`,
`qty_item_loaded`,
`task_status`,
`task_no`,
`dispatch_no`,
`remark`,
`delete_flag`,
`create_time`,
`create_user_code`,
`create_user_name`,
`update_time`,
`update_user_code`,
`update_user_name`,
`tenant_code`,
`task_type`,
`platform_order_no`,
`company_name`,
`company_code`,
`order_no`,
`customer_order_no`,
`order_type`,
`site_code`,
`site_pay_status`,
`invoice_status`,
`invoice_number`,
`wh_code`,
`source_platform`,
`source_system`,
`business_mode`,
`business_type`,
`logistic_mode`,
`aging_product_code`,
`receiver_code`,
`receiver_name`,
`receiver_contact`,
`receiver_tel`,
`receiver_mobile`,
`receiver_virtual_mobile`,
`receiver_country_code`,
`receiver_country_name`,
`receiver_province_code`,
`receiver_province_name`,
`receiver_city_code`,
`receiver_city_name`,
`receiver_district_code`,
`receiver_district_name`,
`receiver_town_code`,
`receiver_town_name`,
`receiver_detail_addr`,
`receiver_detail_code`,
`sender_code`,
`sender_name`,
`sender_contact`,
`sender_tel`,
`sender_mobile`,
`sender_country_code`,
`sender_country_name`,
`sender_province_code`,
`sender_province_name`,
`sender_city_code`,
`sender_city_name`,
`sender_district_code`,
`sender_district_name`,
`sender_town_code`,
`sender_town_name`,
`sender_detail_addr`,
`sender_detail_code`,
`total_gross_weight`,
`total_volume`,
`total_net_weight`,
`total_qty`,
`freight_basis`,
`in_out_type`,
`entity_id`,
`intercep_status_code`,
`qty_item_signoff`,
`invoice_unit_code`,
`invoice_unit_name`,
`act_depart_time`,
`loaded_volume`,
`loaded_gross_weight`,
`start_lng`,
`start_lat`,
`end_lng`,
`end_lat`,
`sign_upload`,
`order_value`,
`outsource_flag`,
`project_classify`,
`order_source`,
`require_depart_time`,
`appointment_time`,
`appointment_remark`,
`appointment_reason`,
`require_out_time`,
`require_arrive_time`,
`site_name`,
`wh_name`,
`mileage`,
`consolidation_no`,
`consolidation_qty`,
`order_time`,
`version`,
`arrival_way`,
`arrival_time`,
`queue_code`,
`actual_arrive_date`,
`arrive_type`,
`customer_aging_code`,
`carrier_code`,
`carrier_name`,
`carrier_issued`,
`upper_receiver_name`,
`upper_sender_name`,
`load_date`,
`electronic_time`,
`car_type`,
`procurement_channel`,
`customer_code`,
`customer_name`,
`plan_order_flag`,
`date_specified_flag`,
`transport_product`,
`receiver_type`,
`sender_type`,
`carrier_visible_flag`,
`supplier_reserve_flag`,
`dispatch_invented_no`,
`require_car_arrive_time`,
`delivery_type`,
`contract_site_code`,
`contract_site_name`,
`contract_customer_code`,
`contract_customer_name`,
`contract_company_code`,
`contract_company_name`,
`require_row_car_time`,
`require_receive_time`,
`require_transfer_time`,
`work_status`,
`dispatch_index`,
`line_name`,
`appointment_times`,
`expect_arrive_start_time`,
`expect_arrive_end_time`,
`transfer_status`,
`upper_order_no`,
`upper_tenant_code`,
`expect_pick_time`,
`costs_amount`,
`revenue_amount`,
`push_bms_flag`,
`professional_company_code`,
`professional_company_name`,
`business_category`,
`business_category_name`,
`contract_no`,
`risk_level`,
`product_code`,
`product_name`,
`discount_amount`,
`final_amount`,
`total_amount`
,CONCAT(receiver_province_name,'-',receiver_city_name) showAreaStr,receiver_province_code showAreaCode
FROM
transport
WHERE
`delete_flag` = 0
AND `create_time` >= ?
AND `create_time` <= ?
AND `task_status` = ?
order by convert(showAreaStr using gbk),create_time desc
limit ?, ?`
the exception messsiong is like that:
`net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
at line 345, column 29.
Was expecting one of:
"&"
"::"
"<<"
">>"
"ASC"
"DESC"
"EMIT"
"NULLS"
"["
"^"
"|"
<EOF>
<ST_SEMICOLON>
`
please heple me fix it