确认

  • [x] 我使用的版本是最新版, 并且使用插件确认过项目里无依赖版本冲突
  • [x] 我已经在 issue 中搜索过, 确认问题没有被提出过
  • [x] 我已经修改标题, 将标题中的 描述 替换为遇到的问题(不得删除 描述 前面的部分)

当前程序版本

3.5.12

问题描述

2025-06-20 17:27:28 [http-nio-9008-exec-4] WARN | com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor >>> optimize this sql to a count sql has exception, sql:"SELECT fb.id, fb.branch_id, ( SELECT org_name FROM sys_org WHERE sys_org.id = fb.branch_id ) AS branchName, fb.bill_no, fb.bill_type, fb.bus_type, fb.settlement_id, fb.settlement_name, (select option_text from base_dict_option where dict_code='billing_cycle' and option_value = fb.settlement_period ) as settlement_period, fb.cust_id, fb.receive_money, fb.receive_cur, fb.received_amount, fb.unreceived_amount, fb.exchange_rate, fb.exchange_formula, fb.converted_rmb, fb.bill_generate_time, fb.bill_generate_type, fb.latest_payment_date, fb.bill_confirm_time, fb.bill_confirm_id, fb.bill_un_audit_time, fb.bill_un_audit_remark, fb.bill_un_audit_id, fb.overdue_days, fb.status, fb.remark, fb.is_del, fb.create_time, fb.update_time, fb.create_by, fb.update_by, fb.info1, fb.info2, ac.payee_name as info3, fb.info4, fb.info5, fb.info6, fb.info7, fb.info8, fb.info9, fb.is_lock_bill, CONCAT_WS('-', fb.receive_cur, fb.unreceived_amount, fb.bill_no), (select option_text from base_dict_option where dict_code='finance_bill_status' and option_value = fb.status ) as statusStr, (select concat(IFNULL(employee_code,""),'-',employee_name) from aaf_employee where user_id = fb.bill_un_audit_id and is_del = '0' )as billUnAuditStr, (select concat(IFNULL(employee_code,""),'-',employee_name) from aaf_employee where user_id = fb.bill_confirm_id and is_del = '0' )as billConfirmStr, ( SELECT org_name_en FROM sys_org WHERE info9 = org_name ) AS orgNameEn, fb.aging_months FROM finance_bill fb

    left join  aaf_cust ac on ac.id = fb.cust_id


     WHERE  fb.bill_type = ?
























































        AND fb.is_del = '0' 
    ORDER BY fb.create_time DESC", exception:

java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "AND" "AND" at line 112, column 13.

Was expecting:

<EOF>

详细堆栈日志

Comment From: miemieYaho

自行配置关闭日志