当前使用版本(必须填写清楚，否则不予处理)
3.1.2
该问题是怎么引起的？(最新版上已修复的会直接close掉)
根据id查询一个实体。
重现步骤
1、表结构如下
报错信息
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, please exclude the tableName or statementId. Error SQL: select id,name,top,ctime ,utime from teacher where id=? at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39) at com.baomidou.mybatisplus.core.parser.AbstractJsqlParser.parser(AbstractJsqlParser.java:74) at com.baomidou.mybatisplus.extension.handlers.AbstractSqlParserHandler.sqlParser(AbstractSqlParserHandler.java:76) at com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor.intercept(PaginationInterceptor.java:146) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) at com.sun.proxy.$Proxy222.prepare(Unknown Source) at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.prepareStatement(MybatisSimpleExecutor.java:94) at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:66) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:136) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ... 48 more Caused by: net.sf.jsqlparser.JSQLParserException at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:154) at com.baomidou.mybatisplus.core.parser.AbstractJsqlParser.parser(AbstractJsqlParser.java:60) ... 58 more Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "top" "TOP" at line 1, column 16.
Was expecting one of:
"("
"*"
"+"
"-"
":"
"?"
"@"
"@@"
"ACTION"
"ANY"
"CASCADE"
"CASE"
"CAST"
"COLUMN"
"COMMIT"
"DO"
"DOUBLE"
"ENABLE"
"END"
"EXTRACT"
"FIRST"
"FOLLOWING"
"GROUP_CONCAT"
"IF"
"INDEX"
"INSERT"
"INTERVAL"
"KEY"
"LAST"
"LEFT"
"MATERIALIZED"
"NO"
"NULL"
"NULLS"
"OPEN"
"OVER"
"PARTITION"
"PERCENT"
"PRECISION"
"PRIMARY"
"PRIOR"
"RANGE"
"REPLACE"
"RIGHT"
"ROW"
"ROWS"
"SEPARATOR"
"SET"
"SIBLINGS"
"TABLE"
"TEMP"
"TEMPORARY"
"TRUNCATE"
"UNSIGNED"
"VALUE"
"VALUES"
"XML"
"{d"
"{fn"
"{t"
"{ts"
"~"
<K_DATETIMELITERAL>
<K_TIME_KEY_EXPR>
<S_CHAR_LITERAL>
<S_DOUBLE>
<S_HEX>
<S_IDENTIFIER>
<S_LONG>
<S_QUOTED_IDENTIFIER>
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:18047)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:17900)
at net.sf.jsqlparser.parser.CCJSqlParser.SelectItem(CCJSqlParser.java:3528)
at net.sf.jsqlparser.parser.CCJSqlParser.SelectItemsList(CCJSqlParser.java:3368)
at net.sf.jsqlparser.parser.CCJSqlParser.PlainSelect(CCJSqlParser.java:2930)
at net.sf.jsqlparser.parser.CCJSqlParser.SetOperationList(CCJSqlParser.java:3107)
at net.sf.jsqlparser.parser.CCJSqlParser.SelectBody(CCJSqlParser.java:2824)
at net.sf.jsqlparser.parser.CCJSqlParser.Select(CCJSqlParser.java:2817)
at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:133)
at net.sf.jsqlparser.parser.CCJSqlParser.Statements(CCJSqlParser.java:250)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:152)
... 59 more
Comment From: miemieYaho
jsqlparser解析异常
Comment From: youyaerpi
怎么造成的呢，top字段换成其他的就不会有问题
Comment From: youyaerpi
mybatis 也不会有这个问题。麻烦大大解决一下我的疑惑🤔
Comment From: miemieYaho
jsqlparser是个解析sql的工具，你用mp最新版试试，jsqlparser有进行锅升级，不行你只有去找jsqlparser