baomidou / mybatis-plus

An powerful enhanced toolkit of MyBatis for simplify development
https://baomidou.com
Apache License 2.0
16.26k stars 4.29k forks source link

[BUG]: xml 有 sample 报net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," "," #6357

Closed kx-hdh closed 3 weeks ago

kx-hdh commented 1 month ago

确认

当前程序版本

MP 版本 3.5.7 数据库是MySQL 8.0

问题描述

使用了大家解决空格的最简易的方式 configuration: shrink-whitespaces-in-sql: true 也使用了 mpBs.sql().replaceAll("(\r?\n){2,}", "$1") 最后发现是sample导致的 SQL是 Parsing SQL: SELECT a.id AS "id",sample.name AS "sample.name" FROM l_sample_out_details a LEFT JOIN l_sample_out_manage sample ON sample.id = a.out_library_id this.parserSingle 会报错

详细堆栈日志

Was expecting one of:

    <EOF>
    <ST_SEMICOLON>

net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," ","
miemieYaho commented 1 month ago

jsqlparser的事你在这里报没用

kx-hdh commented 1 month ago

@miemieYaho 主要之前版本都是好的,是不是考虑换用版本

miemieYaho commented 1 month ago

没那么容易,你可以自己试试看他有没有新版本发布你用报不报错

wzkris commented 1 month ago

降级呗,还能咋

nieqiurong commented 1 month ago

换个别名规避一下.

nieqiurong commented 3 weeks ago

按照规避 net.sf.jsqlparser.parser.CCJSqlParserConstants#tokenImage