确认

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

当前程序版本

3.5.1

问题描述

net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "," "," at line 2, column 1101.

Was expecting one of:

")"
"CONNECT"
"EXCEPT"
"FOR"
"GROUP"
"HAVING"
"INTERSECT"
"INTO"
"MINUS"
"START"
"UNION"
"WINDOW"

详细堆栈日志

Encountered unexpected token: "," ","
    at line 2, column 1101.

Was expecting one of:

    ")"
    "CONNECT"
    "EXCEPT"
    "FOR"
    "GROUP"
    "HAVING"
    "INTERSECT"
    "INTO"
    "MINUS"
    "START"
    "UNION"
    "WINDOW"
jsql 升降版本都没用，issue 里也找了，试了几个不好使啊，

Comment From: 1198735966

看SQL也没有哪些需要按照规避 net.sf.jsqlparser.parser.CCJSqlParserConstants#tokenImage

Comment From: 1198735966

jsql的事，在这能得到解决办法不

Comment From: 1198735966

3.4.1 试了，也报这个问题

Comment From: 1198735966

    String sql = "select count(0) from (" +
            "select mo.* from(SELECT T.SYSID, T.code AS \"code\", T.produ_code AS \"produCode\", T.produ_name AS \"produName\", to_char( T.planned_begin_date, 'yyyy-MM-dd hh24:mi' ) AS \"plannedBeginDate\", to_char( T.planned_end_date, 'yyyy-MM-dd hh24:mi' ) AS \"plannedEndDate\", T.ext10 AS \"linecode\", mm.NAME AS \"linename\", mp.shift_name AS \"shiftName\", T.ext01 AS \"shiftCode\", T.qty AS \"qty\", T.qty - T.complete_qty as \"uncompleteQty\", T.complete_qty - to_number( nullif ( T.ext06, '' ), '9999' ) AS \"qualifyQty\", T.complete_qty AS \"completeQty\", T.ext06 AS \"ext06\", T.receive_qty AS \"receiveQty\", T.ext05 AS \"ext05\", T.seq AS \"seq\", T.STATE AS \"state\", T.ext02 AS \"ext02\", T.ext03 AS \"ext03\", T.ext04 AS \"ext04\", T.ext07 AS \"ext07\", T.ext08 AS \"ext08\", T.ext09 AS \"ext09\", T.ext11 AS \"ext11\", T.ext12 AS \"ext12\", T.ext13 AS \"ext13\", T.ext14 AS \"ext14\", T.ext15 AS \"ext15\", T.lot_code AS \"lotCode\", T.work_order_type AS \"workOrderType\", T.nature as \"nature\", T.order_id AS \"workOrderCode\", T.remark AS \"remark\", T.state_jit as \"stateJit\", T.state_jis as \"stateJis\", us.name AS \"createId\", T.create_date AS \"createDate\", use.name AS \"modifyId\", T.modify_date AS \"mopdifyDate\", mb.drawing as \"drawing\" FROM pa_work_order T LEFT JOIN pa_plan_order order1_ ON order1_.SYSID = T.SYSID LEFT JOIN md_route_line route3_ ON route3_.SYSID = T.route_id AND route3_.is_del = 0 AND route3_.is_active = 0 left join md_bd_mrl mb on mb.code = T.produ_code and mb.is_del = 0 AND mb.is_active = 0 LEFT JOIN md_work_center mm ON mm.code = T.ext10 AND mm.is_del = 0 AND mm.is_active = 0 left join sys_user us on us.username = T.create_id and us.is_del = 0 and us.is_active = 0 left join sys_user use on use.username = T.modify_id and use.is_del = 0 and use.is_active = 0 LEFT JOIN ( SELECT T .code, A.code AS shift_code, A.NAME AS shift_name FROM md_work_shift_class T INNER JOIN md_work_shift A ON T.SYSID = A.work_shift_class_id WHERE T.is_del = 0 AND T.is_active = 0 AND A.is_del = 0 AND A.is_active = 0 ORDER BY T.code, A.code ) mp ON mp.shift_code = T.ext01 WHERE 1 = 1 AND T.is_del = 0 AND T.is_active = 0 order by t.seq desc )mo" +
            " ) tmp_count";
   ;
    Statement parse = CCJSqlParserUtil.parse(sql);
    System.out.println(parse);       解析这个SQL异常，

Comment From: nieqiurong

提交至 https://github.com/JSQLParser/JSqlParser

Comment From: aystnd

我这边是因为类似下面的代码会导致sql生成连续多行，就会导致抛一样的异常，建议JsqlParserGlobal.parse方法内对传入的sql做些预处理，比如去除连续多行 xml配置： AND con.CONSTRUCTION_STATUS in #{item} AND CON.OUTSOURCED_COMPANY like CONCAT(#{params.outsourcedCompany},'%')

    </if>
    <if test="params.outsourcedMonitor !=null and params.outsourcedMonitor !=''  ">
        AND CON.OUTSOURCED_MONITOR=#{params.outsourcedMonitor}
        <!--   AND bu.id=#{params.patroller}-->
    </if>
    ORDER BY
    CON.REPORT_TIME DESC

生成的sql： AND to_char( CON.REPORT_TIME , 'yyyy-mm-dd hh24:mi:ss') >= ? AND to_char( CON.REPORT_TIME, 'yyyy-mm-dd hh24:mi:ss') < ?

        AND CON.company_Code like ?



        AND CON.patroller_id=?








    ORDER BY
    CON.REPORT_TIME DESC

建议去除连续多行： Statement statement = CCJSqlParserUtil.parse(sql.replaceAll("[\n\r]{2,}", "\n"));